Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am working on 3 matrix to show data of this month, next month, and the month after next month. These matrix will update automatically every month. For example, now is Jun, so these matrix show data of Jun, Jul and Aug, respectively. Next month, these will change to Jul, Aug and Sep automatically.
I've 2 questions:
1) When I use DAX like this for the first matrix (this month):
Solved! Go to Solution.
Hi @Anonymous ,
It seems that you want to create the dynamic titles of month for matrix.
By my tests, you could try the measures below.
this month = "forcast start this month,"&FORMAT(TODAY(),"MMMM") next month = VAR next_month = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) + 1, 1 ) RETURN FORMAT ( next_month, "MMMM" ) month after next month = VAR month_after_next_month = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) + 2, 1 ) RETURN FORMAT ( month_after_next_month, "MMMM" )
Here is the output.
Hope this can help you.
Best Regards,
Cherry
Hi @Anonymous ,
It seems that you want to create the dynamic titles of month for matrix.
By my tests, you could try the measures below.
this month = "forcast start this month,"&FORMAT(TODAY(),"MMMM") next month = VAR next_month = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) + 1, 1 ) RETURN FORMAT ( next_month, "MMMM" ) month after next month = VAR month_after_next_month = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) + 2, 1 ) RETURN FORMAT ( month_after_next_month, "MMMM" )
Here is the output.
Hope this can help you.
Best Regards,
Cherry
Thanks Cherry, this works perfect