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

[Silvia_Gulu_BXL]

Hi, lovely people!

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

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!

[tackytechtom · Accepted solution]

Hi @Silvia_Gulu_BXL ,

How about this:

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/

[Silvia_Gulu_BXL]

it worked! many thanks!