79115713

Date: 2024-10-22 21:01:30
Score: 1
Natty:
Report link

How about just checking if the month in question is December and if so, returning 0 instead of the previous month?

VAR vLastMonth = 
    CALCULATE(
        EOMONTH(MAX(DateTable[Date]), -1),
        ALLSELECTED(DateTable[Date])
    )

RETURN 
    IF(
        MONTH(vLastMonth) = 12,
        BLANK(),    // Return 0 instead if you'd like
        CALCULATE(  // Rest of your measure goes here
Reasons:
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Starts with a question (0.5): How
  • High reputation (-1):
Posted by: Michal