Forum Discussion
Solved
Summary table utilizing dynamic dates from slicer
I've got 4 tables: 1. dim_Dates - Dax table with dates from the minimum date in fact_AcqDisp to today(). 2. fact_AcqDisp - from SharePoint and pre-prepared through Power Query. One row per building...
Hi Anonymous
I've solved this by creating a DAX table using GENERATESERIES() to generate 10 rows representing the last 10 years. I cross-joined this table with one of my existing tables and added calculated columns derived from other tables. This gives me a row of data for each building for each year, allowing me to filter by year. Since there are only a couple of hundred buildings, it works well, but I might need to limit the number of years for performance reasons.
