Forum Discussion

mohittimpus's avatar
mohittimpus
Icon for Helper V rankHelper V
5 years ago

current 12 Month based on any filter date

Hello All,

 

I need Current 12 month based on selected date "without any new table" but we can use using measure or calculate column": 
Example:

If I select any date of 2020, I must show only jan-2020 to dec-2020,  12 month (month and year) 
AND 
If I select any date of 2021, I must show only jan-2021 to dec-2021, 12 month (month and year)

showing in below image:



below i am sharing .pbix file: 
https://drive.google.com/file/d/1Hx61gnCCnTy8VdbyBCxPrCqKXeqdoAgB/view?usp=sharing