Forum Discussion
mohittimpus
Helper V
5 years agocurrent 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
2 Replies
- amitchandak
Super User
mohittimpus , refer this youtube video on the similar topic
- v-xulin-mstf
Community Support
Hi mohittimpus,
It is not supported if you do not use dimension table.
Interaction occurs between the slicer and the calculation table.
Best Regards,
Link