Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
it worked! many thanks!
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
86 | |
67 | |
62 | |
53 |