How to input start of financial year based on selected date into measure?

[Bananathan]

Hi,

I have a date slicer that selects the year and month (essentially gives me 30th of selected month and year)

My financial (fin) year runs 1st Apr - 30th Mar and I am trying to input the date '1st April of this fin year' based on the selected date in the slicer.

For example, if I select February 2022 in the slicer then I need 1st April 2021. 

I have a date table with a fin year field (21-22, 22-23, etc.) - I am trying to write DAX to give me 1st April of that fin year using this fin year field as a comparison, but can't figure out how to do this. I've tried DATE(), but I can only get this to work if the year of the selected date happens to be the same as the fin year. Of course, this isn't the case for Jan-Mar.

How can I use selecteddate to create '1st April of this financial year'?

[tamerj1 · Accepted solution]

Hi @Bananathan 

Better to add it as a calculated colum in the date table

DATE ( YEAR ( EOMONTH ( 'Date'[Date], -5 ) + 1 ), 4, 1 )

Inside a measure you need to wrap 'Date'[Date] with SELECTEDVALUE 

[Bananathan]

Awww man this has been bothering the hell out of me, but your solution worked! Thank you so much