Forum Discussion
Maximum values based on two col
Hi all, I have a table called 'Group' with the following table structure: Group Month Value group 1 1 50 group 1 1 100 group 1 1 175 group 1 2 100 group 1 3 100...
Hello tobeggo1996,
For your question, here are three ways to provide:
One.
1. Create a calculated column.
Max_Value_Column = CALCULATE(MAX('Table'[Value]),FILTER('Table','Table'[Group]=EARLIER('Table'[Group])&&'Table'[Month]=EARLIER('Table'[Month])))
2. Result.
二.
1. Create a measure.
Max_Value_Measure = CALCULATE(MAX('Table'[Value]),ALLEXCEPT('Table','Table'[Group],'Table'[Month]))
2. Result.
三.
1. Create a calculated table.
MonthMax_table = SUMMARIZE('Table','Table'[Group],'Table'[Month],"MonthMax_calculation_table",MAX('Table'[Value]))
2. Result.
You can download the PBIX file from here.
Best regards
Liu Yang
If this post helps,then consider Accepting it as the solution to help other members find it faster.