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.
