Dynamic Comparable Spend based on Parameter Year Filter

[jovendeluna21]

Hi,

I have a 'Comparable' filter, and currently, I default the previous year calculation to -1. This means it defaults to 2023, but I want the comparable spend to be dynamic based on the selected fiscal year. For example, when I change to 2022, the current fiscal year number (which in my example is filtered to 2024) should be compared, meaning all the common Site PNs in 2022 and 2024 only. I tried to use 'Last N'[Var], but I am getting an error.

Can you help me with this? Thanks a lot.

I uploaded here the pbi file

https://drive.google.com/file/d/13mOcZwMqymf2cSguEtyEAHG74nnVwrpw/view?usp=sharing

[amitchandak · Accepted solution]

@jovendeluna21, In case you need year by selection, you need a disconnected table to select the second year. Example

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

[jovendeluna21]

Hi, @amitchandak , Thanks for your response, however, I find it hard with my file. Can you try to check? Thank you!

https://drive.google.com/file/d/13mOcZwMqymf2cSguEtyEAHG74nnVwrpw/view?usp=sharing