Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
@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.