Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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[Date]))
I have a similar formula for Last YTD total which is working. No interaction is set with other filters.
Any ideas?