Forum Discussion
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 level, it is not working. Here is my Measure:
I don't know how to write the DAX measure that return the previous month, since some months are 31 days and some are 30 days.
As shown in the figure below, Oct 2002 should return 31, Nov 2022 should return 92.
\
Sorry:
Active Base Count PM = CALCULATE([Active Base count], PREVIOUSMONTH(DimDates[Date]))
5 Replies
DATESINPERIOD() comes into play.
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))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.
Hello:
COGC PM = CALCULATE([Active Base count], PREVIOUSMONTH(Dates[Date]))Thanks..Sorry:
Active Base Count PM = CALCULATE([Active Base count], PREVIOUSMONTH(DimDates[Date]))
