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,520 points
4,567 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,910 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 1,201 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,360 points
330 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,360 points
650 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
804 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 21, 2019 in Power BI by Avantika
• 1,520 points
1,215 views
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,910 points
1,533 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,910 points
3,568 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,910 points
4,083 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP