Maximum YoY% or MoM%

[DR2022]

Hi! How can a measure be made that returns the maximum YoY% or MoM% measure value?

[v-eqin-msft]

Hi @DR2022 ,

Any updates?

Sorry for that the information you have provided is not making the problem clear to me. 

You may refer to the blogs to know

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[amitchandak · Accepted solution]

@DR2022 , Assume you  already have YOY% and MOM% measures

Max([YOY%], [MOM%])

or

sumx(Values('Date'[Month Year]), calculate(if([YOY%]> [MOM%],[YOY%], [MOM%])) )

or

sumx(Values('Date'[Month Year]), calculate(Max([YOY%], [MOM%])) )

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

[DR2022]

But it shouldn't be for example:

CALCULATE(MAX([Sales YoY%]), Date[YearDate] ?

I'm sorry that I don't understand.