Define Year End

[jayanthan]

Hi All

How do i define Year End in Power BI dax function, i was trying to use in previous year and sameperiodlastyear functions, it does not work, could you please send me sample pbix with those functions. In my country , year ends on 31st March 

Regards

Jayanthan

[themistoklis]

@jayanthan

Maybe the function DATEADD and PARALLEPERIOD will be of use to you.

You can offset dates using the above function.

Check this link as well.

[jayanthan]

Hi themistoklis

Thank you , i could not define year end with those functions, could you please help

Regards

Jayanthan

[v-chuncz-msft · Accepted solution]

@jayanthan,

You may try DATESYTD and TOTALYTD.