Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
92 | |
81 | |
70 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |