Using Power Query, can I convert a text or number column to a Month in Calendar (date) column? The data look like this:
Go to Solution.
As AlB said, if you have a [year] column, then use this formula
#date([year], [MonthNumber], 1)
View solution in original post
You can for instance add a custom column with this code for the column:
= #date(2020, [MonthNumber], 1)
to create the first day that month in 2020. change as required if you want another year or day
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Thanks. That works for 2020. Can hard-coding the year be avoided?
Sure, as I said in the previous post, update the year or day with whatever is required
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.