Reply
Iaine
New Member
Partially syndicated - Outbound

Changing YYYYMM to a valid date format

I wonder if anyone has figured out how to take 'YYYYMM' as a number field to turn it into a valid time period in power query. I have manged it in Power Bi Desktop, but as i need to do some things on it in power query it does not show.

 

Any help would be awesome 

 

Iain 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @Iaine ,

 

You could create a new custom column, something like this:

#date(
    Number.From(Text.Start(Text.From([dateKeyField]), 4)),
    Number.From(Text.End(Text.From([dateKeyField]), 2)),
    01
)

 

This gives me the following output:

BA_Pete_0-1662393261165.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
AlexisOlson
Super User
Super User

Syndicated - Outbound

You can also use math functions to isolate the year and month components.

 

#date(
    Number.IntegerDivide([Column1], 100),
    Number.Mod([Column1],100),
    1
)

 

 

Another option is to use Date.FromText with an explicit Format specification:

 

Date.FromText(Text.From([Column1]), [Format="yyyyMM"]))

 

BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @Iaine ,

 

You could create a new custom column, something like this:

#date(
    Number.From(Text.Start(Text.From([dateKeyField]), 4)),
    Number.From(Text.End(Text.From([dateKeyField]), 2)),
    01
)

 

This gives me the following output:

BA_Pete_0-1662393261165.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)