Forum Discussion

cyberdejy's avatar
cyberdejy
Regular Visitor
3 years ago

Return max monthly output value

Hi, I have a DAX for highest Daily and Monthly sales. The daily formula works perfectly when whatever I select it just gives me the highest daily output - no problem. But when I want to get the mo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  cyberdejy ,

I created some data:

 

Here are the steps you can follow：

1. Create measure.

Measure =
var _select = SELECTCOLUMNS('Table',"1",[Year])
return
FORMAT(
MAXX(
    FILTER(ALL('Table'),'Table'[Value]=
MAXX(
    FILTER(ALL('Table'),'Table'[Year] in _select),[Value])),[Date]),"mmmm")

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

cyberdejy's avatar
cyberdejy
Regular Visitor
3 years ago

Hi and thanks for your feedback.

The way I see your example table - the highest value in year 2022 is (24) and the highest value in 2023 is (26) .. All I want is to have as a result when selecting both year 2022 and 2023 to get the highest value which is 26.

And if I select all three years then it should return (39) as the highest day value as per your example.

At the moment as it happend before with my tables when selecting multiple years it returns the sum instead of the single highest value accross all years.