Support Date Result based on Fiscal Year

[JB17]

Hi Everyone,

Can you help me create DAX for below table? I was trying to get the result yearly. So let say the support date of Product A is Jan 3, 2019, the result will be 2019 because the support date falls within the FiscalYear 2019. I will appreciate all your help!

Thanks!

[Anonymous · Accepted solution]

Hi @JB17 ,

I suggest you to try code as below to create a calculated column.

Result = 
YEAR ( EOMONTH ( 'Table'[Support Date], 2 ) + 1 )

Result is as below.

Best Regards,

Rico Zhou

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

[Mahesh0016]

@JB17 I hope this helps you.

YEARS = YEAR(Table[Support Date])

Thank You.