Forum Discussion
Calculate sum Max
Hi, Anonymous
According to your description, I created the following sample data and wrote a calculated column of DAX expressions based on these data:
DAX formula:
Column = VAR _name = 'Sheet4 (3)'[commune] VAR _table = FILTER ( 'Sheet4 (3)', 'Sheet4 (3)'[commune] = _name ) RETURN CALCULATE ( MAXX ( _table, 'Sheet4 (3)'[donnée] ) )The result is as follows:
In the scenario of Commune A, the biggest value of finding each month is 6. I provided the pbix file used this time. If the above DAX can help you, it is great.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I want to do this:
Create a column that searches for maximum values by commune and month.
Then sum the maximums obtained.
If for a commune A I have in January 7, in February 2 and in March 6, the formula should look for the maximum of values for commune A per month. In this case, the new column should give 7. and so on until I have all the maximum data per commune and then add them together.
Hi, Anonymous
According to your description, I created the following sample data and wrote a calculated column of DAX expressions based on these data:
DAX formula:
Column =
VAR _name = 'Sheet4 (3)'[commune]
VAR _table =
FILTER ( 'Sheet4 (3)', 'Sheet4 (3)'[commune] = _name )
RETURN
CALCULATE ( MAXX ( _table, 'Sheet4 (3)'[donnée] ) )
The result is as follows:
In the scenario of Commune A, the biggest value of finding each month is 6. I provided the pbix file used this time. If the above DAX can help you, it is great.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.