Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have a month column (January, February and so on) and a year column (2019, 2020 and 2021). I want to get a date column from they both. I recall once I saw a video where I could do something like #date(2020,"January",1) and it returns 1/1/2020 as date.
I do not remember the code but I hope you get what I am trying to achieve.
Thanks!!!
Solved! Go to Solution.
You need to use this syntax - #date(2020,1,1)
Or you can add a column with this expression (assumes Year is number column).
= Date.From([Month] & Text.From([Year]))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You need to use this syntax - #date(2020,1,1)
Or you can add a column with this expression (assumes Year is number column).
= Date.From([Month] & Text.From([Year]))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |