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.
in Power Query you can use Add Column from Example . Right Click on Date Column and use Add column from Example which will invoke a Blank Column in the Extreme Right. Change the column name what ever you want and inthe First Row Type 1 (assuming the Date in that row is 1st ) and click OK to get only date number 1,2,3 etc .
Let me know if this helps or need any further help!