Create dynamic table in PowerBI

[Murali777]

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.

[amitchandak · Accepted solution]

@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.