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
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
395 | |
103 | |
68 | |
55 | |
49 |
User | Count |
---|---|
379 | |
117 | |
81 | |
67 | |
53 |