topic Re: DAX Commands Current Month in DAX Commands and Tips

DAX Commands Current Month

spandy34 — Wed, 23 Feb 2022 10:13:28 GMT

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 FinCalendar Table which is my calendar table see diagram below

Recoveries No Successful Recoveries Uninsured Loss =

CALCULATE (

COUNTROWS ( 'Main Claim Data' ),

FILTER (

'Main Claim Data',

'Main Claim Data'[ClassOfBusinessCode] = "OT"

&& CONTAINSSTRINGEXACT ( [PolicyCode], "REC" ))

Amount Recovered Uninsured Loss £ = CALCULATE(SUM('Main Claim Data'[Net]),'Main Claim Data'[ClassOfBusinessCode] = "OT" && 'Main Claim Data'[REC_Code_Column] > 0)

Team Fee Income Uninsured Loss £ = CALCULATE(SUM('Main Claim Data'[Net]),'Main Claim Data'[ClassOfBusinessCode] = "OT" && 'Main Claim Data'[REC_Code_Column] > 0 && 'Main Claim Data'[ADMIN_Code_Column] >0)

Re: DAX Commands Current Month

amitchandak — Wed, 23 Feb 2022 10:34:19 GMT

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

Re: DAX Commands Current Month

spandy34 — Wed, 23 Feb 2022 11:05:58 GMT

Thank you so much amitchandak