topic If current month hours are blank, then use previous month hours instead in DAX Commands and Tips

If current month hours are blank, then use previous month hours instead

cgreen1 — Thu, 05 Mar 2026 22:59:05 GMT

I need help writing a measure to utilize the previous month's hours when the current month's hours are blank.

MasonMA — Thu, 05 Mar 2026 23:26:06 GMT

If you do not have a Calendar table yet in your model, build one, mark it as a date table and create a relationship with your Fact table.

Then use a Measure like

Measure =

VAR Curr =

SUM(Fact[HOURS_TOTAL])

VAR Prev =

CALCULATE(

SUM(Fact[HOURS_TOTAL]),

DATEADD('Calendar'[Date], -1, MONTH)

)

RETURN

IF( ISBLANK(Curr) || Curr = 0, Prev, Curr )

cgreen1 — Fri, 06 Mar 2026 15:31:58 GMT

Thank you, it worked!