Card Visuals

[vishnu-Prasad]

Need to create a 3 cards visuals individually in the dashboard as NOV-2022, Dec-2022, Jan-2023. However, these cards should be changed dynamically when the next month comes, like: Dec-2022, Jan-2023, Feb-2023 and it should refreshed every month on the same logic.

[v-jianboli-msft · Accepted solution]

Hi @vishnu-Prasad ,

Please try:

L1 = 
var _a = FORMAT(EOMONTH(TODAY(),-1),"MMM-YYYY")
return _a

L2 = 
var _a = FORMAT(EOMONTH(TODAY(),-2),"MMM-YYYY")
return _a

L3 = 
var _a = FORMAT(EOMONTH(TODAY(),-3),"MMM-YYYY")
return _a

 Final Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.