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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Silvia_Gulu_BXL
Frequent Visitor

Create date from columns with "day" and "month" granularity M function

Hi, lovely people!

I want to create date from "Day" and "Month" columns:

Silvia_Gulu_BXL_0-1656838638030.png

I tried "Date.FromText" with the "day" and "month" converted to text.

--------------------------

Date.FromText(Text.From([#"Date Granularity.Level 3: Day"]),Text.From([#"Date Granularity.Level 2: Month"]),"2022")

---------------------------

 

But I got an error.

Could you help please?

Many thanks!

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @Silvia_Gulu_BXL ,

 

How about this:

tomfox_0-1656840147010.png

 

The formular I used is:

#date(2022, [Month], [Day])


Let me know if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
tackytechtom
Super User
Super User

Hi @Silvia_Gulu_BXL ,

 

How about this:

tomfox_0-1656840147010.png

 

The formular I used is:

#date(2022, [Month], [Day])


Let me know if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

it worked! many thanks!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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