Forum Discussion
Solved
Create dynamic table in PowerBI
Hi All, I want to create the dynamic calculate table based on the Year column in the Dim_Calendar table. Currently i'm doing like static like in the screenshot below.
Murali777 , You have to generate and filter .
Refer to the file attached. Use generate in place of crossjoin
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Murali777 , You have to generate and filter .
Refer to the file attached. Use generate in place of crossjoin
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.