Forum Discussion

TonyGu's avatar
TonyGu
Icon for Helper I rankHelper 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]))

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago

DATESINPERIOD() comes into play.

TonyGu's avatar
TonyGu
Icon for Helper I rankHelper I
4 years ago

I tried this measure but it's not giving what I want.

 

Active Patient Base PM =
CALCULATE([Active Base count],
DATESINPERIOD(
DimDates[Date],
MAX(DimDates[Date])-31,
-1,MONTH)
)
 

 

 
 
  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Not surprising at all that you can't get the right answer. You should learn DAX from scratch, the very first thing is that DAX is NOT Excel worksheet formula; DAX formula is very sensetive to the context where it evaluates. Thus, any discussion over DAX without dataset model is nothing but gibberish.