Extract date in the table

[Anonymous]

Hi All,

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

Thanks,

Zuheb

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

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.

Regards

[Anonymous]

Working for me thanks...

[MFelix]

Hi @Anonymous,

Try the DATEADD function using the LEFT/RIGHT you can get the information from other columns to add the year/month/day.

Regards,

MFelix