Forum Discussion
Filter KPI Value Relative to Selected Date
Hi WillDetzel
In my opinion, it is necessary to create a calendar, and this calendar cannot have a relationship with your main table.
This allows you to select the corresponding date in the calendar and use Measure to determine it.
How to Get Your Question Answered Quickly
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thanks for tour reply!
I actually changed my approach, and talked to my client, we decided to not have such a historic table with the KPIs, and ended up just making a measure with an IF statement that changes the result based on the selected date.
Hi WillDetzel
In my opinion, it is necessary to create a calendar, and this calendar cannot have a relationship with your main table.
This allows you to select the corresponding date in the calendar and use Measure to determine it.
How to Get Your Question Answered Quickly
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for tour reply!
I actually changed my approach, and talked to my client, we decided to not have such a historic table with the KPIs, and ended up just making a measure with an IF statement that changes the result based on the selected date.