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
5,544 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,770 points

edited Sep 25, 2020 by Gitika

Related Questions In Power BI

0 votes
1 answer

How can I reduce the memory usage of a complex DAX calculation that involves multiple SUMX() iterations?

To reduce memory usage in a complex ...READ MORE

answered Mar 10 in Power BI by anonymous
• 31,450 points
102 views
+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,975 views
+1 vote
2 answers

How do I register for a certification test for the pl 300?

These are the steps that can be ...READ MORE

answered Oct 25, 2024 in Power BI by pooja
• 24,150 points
680 views
0 votes
1 answer

What are the best practices for optimizing DAX queries that use multiple CALCULATE statements?

To optimize DAX queries that involve using ...READ MORE

answered Oct 29, 2024 in Power BI by pooja
• 24,150 points
257 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,661 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,770 points
2,068 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,770 points
4,441 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,770 points
4,829 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