Forum Discussion

spandy34's avatar
spandy34
Responsive Resident
4 years ago
Solved

DAX Commands Current Month

I have three DAX Statements and I would like to include results for the current month.  Please can someone tell me how to amend to reflect this please - based on the Notification Date - I have a FinC...
  • amitchandak's avatar
    amitchandak
    4 years ago

    spandy34 , For a selected month time intelligence and date table

    example

     

    MTD Sales = CALCULATE([Recoveries No Successful Recoveries Uninsured Loss],DATESMTD('Date'[Date]))

     

     

    This month Today =
    var _min = eomonth(today(),-1)+1
    var _max = eomonth(today(),0) //today()
    return
    CALCULATE([Recoveries No Successful Recoveries Uninsured Loss], FILTER(ALL('Date'),'Date'[Date] >= _min && 'Date'[Date] <=_max ) )

amitchandak's avatar
amitchandak
Super User
4 years ago

spandy34 , For a selected month time intelligence and date table

example

 

MTD Sales = CALCULATE([Recoveries No Successful Recoveries Uninsured Loss],DATESMTD('Date'[Date]))

 

 

This month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0) //today()
return
CALCULATE([Recoveries No Successful Recoveries Uninsured Loss], FILTER(ALL('Date'),'Date'[Date] >= _min && 'Date'[Date] <=_max ) )