Forum Discussion
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...
Hi cyberdejy ,
I think the problem is what the DAX you have written.
I the DAX you have shared, there is a SUM function which I think is performing the sum of Values. In a day where there is a single entry, your DAX might work, but for days with multiple values for it, this should still be an issue
Try removing the SUM and see.
Max Daily O/Put = MAXX(VALUES('Calendar'[Date].[Date]),CALCULATE('COEX - List'[Output Kg]))
Max Monthly O/Put = MAXX(VALUES('Calendar'[Date].[Month]),CALCULATE('COEX - List'[Output Kg]))
Regards,
Hi and thanks for the reply. It must have sum as its not a measure so it need to sum all the values in this column (Output Kg) and bring the max value for the selected period. For example if I select years 2023,2022,2021 etc. I want as ruturn the month with the highest value.