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 25, 2020 in Power BI by anonymous
• 10,480 points
1,782 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 25, 2020 by Gitika
• 65,950 points

edited Sep 25, 2020 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 492 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
• 52,370 points
120 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
• 52,370 points
239 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,570 points
389 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,950 points
369 views
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, 2020 in Power BI by Gitika
• 65,950 points
1,439 views
0 votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

You can access column variables of previously ...READ MORE

answered Oct 8, 2020 in Power BI by Gitika
• 65,950 points
1,735 views