Forum Discussion
Solved
Custom Date Field
Hi guys, I need some help creating a custom date field that goes off of our Financal Year (June - May) I have in mind: >May 21 June - Dec 21 2022 2023< Years will change depending on c...
Hi paulfink ,
Based on your description, you can create a calculated column as dollows.
Column =
IF (
MONTH ( 'calendar'[Date] ) < 5
|| MONTH ( 'calendar'[Date] ) = 5
&& [Date].[Day] <= 21,
MONTH('calendar'[Date])&"/"&DAY('calendar'[Date])&"/"&YEAR('calendar'[Date]),
IF ( MONTH ( 'calendar'[Date] ) = 5 && [Date].[Day] > 21,">May "&(1+YEAR('calendar'[Date])), "June-Dec "&YEAR('calendar'[Date])+1 )
)Result:Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
paulfink , Not very clear what you, If you need FY calendar, Jun _may., Get from my blog
I have a FY column on my calendar table already - our FY is from Start of June to End of May next year.