Forum Discussion
Custom Date Field
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.
Hi paulfink ,
Sorry for that the information you have provided is not making the problem clear to me. Can you please explain with an example. Can you kindly share some sample data and the expected result to have a clear understanding of your question? You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Best Regards,
Yuna
