Forum Discussion
HOW TO CHANGE WHOLE NUMBER TO DATE (YEAR AND MONTH)
Hi Community, please help me in this: i dont know how to change WHOLE NUMBER TO DATE (YEAR AND MONTH) datatype. I have excel files that always display the month as 1, 2, 3 and year as 2021, 202...
parry2k
Super User
Super UserYUHU2344 add a new column in Power Query with the following expression.
#date([Create_Year],[Create_Month],1)
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo