topic Re: Measures - Year to Date in DAX Commands and Tips

Measures - Year to Date

spandy34 — Wed, 23 Feb 2022 10:15:04 GMT

I have three DAX Statements and I would like to include results for Year to Date. 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: Measures - Year to Date

Anonymous — Wed, 23 Feb 2022 11:10:33 GMT

Hi spandy34
you can try

1)

Recoveries No Successful Recoveries Uninsured Loss = CALCULATE ( COUNTROWS ( 'Main Claim Data' ), FILTER ( 'Main Claim Data', 'Main Claim Data'[ClassOfBusinessCode] = "OT" && CONTAINSSTRINGEXACT ( [PolicyCode], "REC" )), DATESYTD('Fin_Calendar'[Date]))

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

Regards,
Aditya

Re: Measures - Year to Date

spandy34 — Wed, 23 Feb 2022 11:01:33 GMT

Thank you

THe response for 1) I get the following

The others are bringing no results

THis is what Im trying to achieve and strugging a bit

Re: Measures - Year to Date

v-zhangti — Tue, 01 Mar 2022 08:13:24 GMT

Hi, spandy34

Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.