Forum Discussion
Last MTD Formula
I'm using the following Last MTD Costs formula to show a floating cost total in a card. It's showing BLANK. Last MTD Costs = CALCULATE(SUM('Usage Details - 2'[Cost]),PREVIOUSMONTH(dateDimension[...
That makes sense!
I want it to be dynamic. How would I accomplish that? Incorporating the TODAY function?
Hi anelliaf ,
Do you try the way that amitchandak suggested? Have you resolved the problem? If yes, please accept the helpful answer as a solution. If you still need help, can you please share a dummy file? Then we will understand clearly about your situation.
I will be trying to apply his suggestion today. I'll update the post after doing so.