Forum Discussion

rachelbabcock's avatar
rachelbabcock
Helper I
5 years ago
Solved

How to pull Day from Date in Power Query Editor

Hi! I have a question that should hopefully be simple to resolve.   In my dataset, I have a "dates" column that includes every single day between January 1 and December 31. I need to narrow this to...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    rachelbabcock 

    1) Select the date column in Power Query, select add a new column, and select the Date options in the ribbon:

     

    You will get this

     

    2) Now select the day column and filter out the days you don't need.

     

     

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hello!

I am trying your solution but when I extract the day, it gives me one less number, that is, the date 28/11/22, it gives me day 27

Best regards

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Anonymous 

Try changing the Fecha.Fallo column to type Date (not Date/time) before adding the Day column