Forum Discussion

TonyGu's avatar
TonyGu
Helper I
4 years ago
Solved

DAX Measure needs Help

I am trying to writing a measure that return the count of active patient of the previous month. I have written a measure that return the count of previous year working. But when I expand to month lev...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Sorry:

    Active Base Count PM = CALCULATE([Active Base count], PREVIOUSMONTH(DimDates[Date]))

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hello:

 

COGC PM = CALCULATE([Active Base count], PREVIOUSMONTH(Dates[Date]))
 
Thanks..
  • Whitewater100's avatar
    Whitewater100
    Solution Sage
    4 years ago

    Sorry:

    Active Base Count PM = CALCULATE([Active Base count], PREVIOUSMONTH(DimDates[Date]))