I have a text field that contains year and month only (ex '201801'). How do i create a date field using this text field.
Solved! Go to Solution.
create a new column in same table with following code where varible _Date can be equal to other column in a table with dates.
3rd argument of the DATE function defines a day. In my case the result will be 1/1/2018
= VAR _Date = "201801" RETURN DATE(left(_Date,4),MID(_Date,5,2),1)
Hi, I have this formula
Businessdate = DATE(LEFT([BUS_YEAR_MTH],4),MID([BUS_YEAR_MTH],5,2),1)
but it is giving me this error:
Expression.Error: The name 'DATE' wasn't recognized. Make sure it's spelled correctly.
Thanks for your help!
Open Power BI Desktop,click on "New column" from the home menu, "DATE" function should be possible.
works fine for me. try to use this sample as per link below.
Alternative solution, Greg offered, should also work fine, use either one.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!