cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

date format transformation into a new column

Hi,

 

I have a date column format (month ,day, year) ranging from January 2015 to December 2017.  I would like to create a new column such as January 2015 to May 2016 is recorded as 1,  June 2016 to January 2017 as 2, Feb 2017 to Dec 2017 as 3.  Is there a Dax function allowing such transformation? Or what would be the DaX formula in powerbi?  

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Hi,

 

This is my first proposal as a solution, pretty sure there are better answers and please don't laugh too hard (experts).

 

=if([Date]<=date(2016,05,31),1,if([Date]<=date(2017,01,31),2,3))

View solution in original post

2 REPLIES 2
Highlighted
Helper II
Helper II

Hi,

 

This is my first proposal as a solution, pretty sure there are better answers and please don't laugh too hard (experts).

 

=if([Date]<=date(2016,05,31),1,if([Date]<=date(2017,01,31),2,3))

View solution in original post

Highlighted

Yup..... It works perfectly. Laughting at myself as it was so simple, an IF function.  Thanks soooo much you JP-Ronse

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors