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]))

CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago

DATESINPERIOD() comes into play.

  • TonyGu's avatar
    TonyGu
    Helper 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
      Community 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.