need to convert the static measure to dynamic measure and for upcoming years also

[yuktadiya]

hi All

diff =

var le = CALCULATE(SUM('SBA Data'[Sum of Amount]),'SBA Data'[Year]="2022 LE")

var P = CALCULATE(SUM('SBA Data'[Sum of Amount]),'SBA Data'[Year]="2022P")

 return

 divide (le -p,p)

note : i need to show difference and differene in percetange  

Year	Amount
2022 LE	145.26
2022LE	100.05
2022 LE	86.25
2022 LE	93.15
2022 P	22.65
2022 P	58.62
2022 P	26.95
2022 P	59.63
2022 P	100.01

regards

Dilip

[v-yueyunzh-msft]

Hi , @yuktadiya 

Thanks for your sample data , and for your need , you said that you want to "convert the static measure to dynamic measure and for upcoming years also"?

I do not understand what is the dynamic measure for you? For your dax , you just calculate the percentage between the "2022 LE" and "2022 P"? And what the end result you want in  the visual?

If this method does not meet your needs, you can provide us with your  desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[Syndicate_Admin]

Hello

Is the measurement formatted correctly? if it is correct could you show me how you are doing the division in DAX?