Solved: Transferring date as a number NOT a text?

zicarelli · ‎03-30-2023

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

Marco

amitchandak · ‎03-30-2023

@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])

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎03-30-2023

@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])

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

zicarelli · ‎03-31-2023

Thanks, mate! Will do it.

Transferring date as a number NOT a text?

Helpful resources

Power BI May 2023 Update

Data Stories Gallery

How to Get Your Question Answered Quickly