Forum Discussion
Summary table utilizing dynamic dates from slicer
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.
Hi, Samand
Thank you for your reply. If you want to do this, you can still do things like read your SharePoint into a database, and then Power BI connects to those databases to do what you want. Or you just need to create some measures that use summarize to create some virtual tables, and then reflect the corresponding results in the visuals.
Best Regards
Jianpeng Li
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.