Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
zicarelli
New Member

Transferring date as a number NOT a text?

Hi everyone.

I just got started with Power BI and I am struggling to transform a date/month (Ex.: August) as a number in Power BI? When it gets to Power BI desktop it reads as text (please, see the image attached). Any hints? I need to have August as a month/number?

Cheers

Marcoscreenshot_date_column.jpg

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@zicarelli , No power will take that as text only, You have to create date with help from the year and month

 

Date.FromText("01-" &[Month] & "-" & Text.Start[Year])

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@zicarelli , No power will take that as text only, You have to create date with help from the year and month

 

Date.FromText("01-" &[Month] & "-" & Text.Start[Year])

Thanks, mate! Will do it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.