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 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
Ok. If you're experiencing performance issues, you can try the built-in performance monitoring tools in Power BI desktop:
Or you can use DAX studio to see the overall performance. If the performance penalty is not significant, then you can maintain your current practices. If the performance is slow, you need to generate the number of years as you say now.
I think if you only need this table, you can do it by entering the table without having to calculate the table generation, which will greatly improve the report performance.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.