Forum Discussion
Resolver IIpercentage value changes when future month is selected
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.
Tp incr % Vs 2020 when not selected 2022_4
Tp incr % Vs 2020 changing when selected 2022_4
3 Replies
- lbendlin
Super User
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 
Varshi288Hi 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 selectedTP 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.
