Calculate MAX over measure per date

[Sof]

Hello,

I have a problem I hope you can help me with. I have a measure calculating an amount per hour of each day of each month of each year. Now I want to calculate the max of this measure over a day. I have found solutions to solve this for a column, but not for a measure. Can someone help me with this? I am new to power BI, so I don't understand the DAX language completely yet.

Thanks!

[v-jiascu-msft · Accepted solution]

Hi @Sof,

Maybe you could try this formula with some changes: (the blue part could be your current measure.)

Measure =
SELECTCOLUMNS (
    TOPN (
        1,
        SUMMARIZE ( Sales, 'Sales'[Hour], "Amount", SUM ( Sales[Quantity] ) )
    ),
    "FinalAmount", [Amount]
)

Then your report could be like this:

Year   Month  Day  Measure

Please have a try. If you need more help, please post a sample here in a text mode. The PBIX file would be great if possible.

Best Regards!

Dale