I want to extract date in the table. I have Month and number between 1 to 31, it there any function that help me extract date for the month. I don't want to use concatenate function as data type for concatenate is text format.
Month Attribute Date
8/01/2017 1 08/01/2017
8/01/2017 2 08/02/2017
8/01/2017 3 08/03/2017
6/01/2017 10 06/10/2017
Go to Solution.
Based on my test, you should be able to simply use the formula below to add a calculate column to your table to extract data for the month in this scenario.
Date = Table1[Month] + Table1[Attribute] - 1
Note: just replace 'Table1' with your real table name.
View solution in original post
Working for me thanks...
Try the DATEADD function using the LEFT/RIGHT you can get the information from other columns to add the year/month/day.
Proud to be a Super User!
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!