Forum Discussion

Upali63's avatar
Upali63
Helper II
2 years ago
Solved

Need Modification to DAX created in my object

Hi Friends   I have with the help of community members(I am new to Power BI) has witten a Measure which is follows   But now I find that there is an error and  I am not getting values in Mo...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Try the below dax and change as per your need.

PrevMonth = 
VAR CurrentMonth = max('dm_tm'[cl_dt])

VAR PrevMonthStartDate =EOMONTH(CurrentMonth,-2)+1
VAR PrevMonthEndDate = EOMONTH(CurrentMonth,-1)
vAR  Result=CALCULATE(
    count('dm_tm'[cl_dt]),
    'dm_tm'[cl_dt] >= PrevMonthStartDate,
    'dm_tm'[cl_dt] <= PrevMonthEndDate
)

RETURN
Result
  • Upali63's avatar
    Upali63
    Helper II
    2 years ago

    Hi Anil

    Below is the result after applying your formula. Kindly correct me