DAX Calculation the Max for a Group.

0 votes

I would like the 'Desired Output' column to be the Max of the 'Check' column.  I have a problem and have a feeling a simple DAX formula can solve it. 

Sep 24 in Power BI by anonymous
• 4,530 points
24 views

1 answer to this question.

0 votes

You can try this out: 

Desired Output=CALCULATE(MAX([Check]),FILTER(Table1,[Name]=EARLIER([Name]))

answered Sep 24 by Gitika
• 41,080 points

edited Sep 25 by Gitika

Related Questions In Power BI

+1 vote
1 answer

Need a DAX : To check the new escalations arrived, on the change of the escalation counter from zero to one or more

Yes exactly !  i need a measure for ...READ MORE

answered Sep 3, 2019 in Power BI by anonymous

edited Sep 3, 2019 308 views
0 votes
1 answer

Looking for a way to to list all cloud services with their description

A jQuery selector like this should do ...READ MORE

answered Sep 21, 2018 in Power BI by Kalgi
• 51,970 points
68 views
0 votes
1 answer

What are the components I need to excel to become a pro in power BI

Having knowledge about these topics is a must.  Power ...READ MORE

answered Oct 8, 2018 in Power BI by Kalgi
• 51,970 points
143 views
0 votes
1 answer

Dax code for calculated columns

I would recommend you to adjust the ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,410 points
246 views
0 votes
1 answer

How do I label bar graph with different colors based on values from different slicers?

If the user selects only one value ...READ MORE

answered May 20, 2019 in Power BI by avantika
• 1,500 points
184 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

dax calculation for last N days

Hi, @Vnk, Regarding your above query, you can ...READ MORE

answered Jun 30 in Power BI by Gitika
• 41,080 points
269 views
0 votes
1 answer