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
Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

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!

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!