Forum Discussion
Maximum YoY% or MoM%
Hi! How can a measure be made that returns the maximum YoY% or MoM% measure value?
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
4 Replies
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=6LUBbvcxtKABut it shouldn't be for example:
CALCULATE(MAX([Sales YoY%]), Date[YearDate] ?
I'm sorry that I don't understand.
Hi,
Share some data and show the expected result.
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
