Forum Discussion
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...
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.
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.
I knew it was something easy I just hadn't considered..THANK YOU!
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
Anonymous
Try changing the Fecha.Fallo column to type Date (not Date/time) before adding the Day column
