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!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!