cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Extract date in the table

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

 

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft
Microsoft

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. Smiley Happy

Date = Table1[Month] + Table1[Attribute] - 1

Note: just replace 'Table1' with your real table name.

 

c3.PNG

 

Regards

View solution in original post

3 REPLIES 3
v-ljerr-msft
Microsoft
Microsoft

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. Smiley Happy

Date = Table1[Month] + Table1[Attribute] - 1

Note: just replace 'Table1' with your real table name.

 

c3.PNG

 

Regards

Anonymous
Not applicable

Working for me thanks... Smiley Happy

MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!