Forum Discussion

YUHU2344's avatar
YUHU2344
Frequent Visitor
3 years ago

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, 2020 but these are whole number. I want to change this to an actual date format. The other articles I've read have not worked for me. Any help is appreciated. I'm still learning how this all works. Example below.

 

 

 

thank you,

your help will be greatly appreciated

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    YUHU2344 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