percentage value changes when future month is selected

[Varshi288]

Hi I have two measures comparing TP incr % for Previous year(2021)  and Last 2 years(2020). When we selected future months Like 2022_4 % value is changing for 2020 meausre where as for previous year measure  not changing. My requirement is not to change the value until data is added to that month.

MP 2020 (TP) = CALCULATE([MP (TP)], PARALLELPERIOD(Period2[Date],-2,YEAR))

TP incr vs 2020 = SUMX(PriceImpact,(1-MIN(2,MAX(DIVIDE([MP 2020 (TP)],[MP (TP)]),0.5)))*[TP_price increase ])

TP incr % vs 2020 = DIVIDE([TP incr vs 2020],[Cov TP 2020]-[TP incr vs 2020])

MP PrY (TP) = CALCULATE([MP (TP)], PREVIOUSYEAR(Period2[Date]))

TP incr PrY = SUMX(PriceImpact,(1-MIN(2,MAX(DIVIDE([MP PrY (TP)],[MP (TP)]),0.5)))*[TP_price increase])

TP incr % Vs PrY = DIVIDE([TP incr PrY],[Cov TP]-[TP incr PrY])

Tp incr % Vs 2020  when not selected 2022_4

Tp incr % Vs 2020 changing when selected 2022_4

[Varshi288]

Hi @lbendlin ,

First thanks for the reply. I tried to create sample data in high level hope this will be fine. My question as per screen shot is that when future months are selected TP incr % Vs Pry is not changing but TP incr % Vs 2020 is changing.

All the mesures used are in are in above post.

                 when                      2020_4 not selected             2020_4 selected

      TP incr % Vs Pry                     10.0%                                   10.0% 

      TP incr % Vs 2020                   23.6%                                   21.1%  (it shuld be 23.6%)

Hope that you got it.

[lbendlin]

Without usable sample data I won't be able to help.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523