Forum Discussion
Power Query Date Column: to display month based on an existing column
Hi nic2023 ,
Raw data:
Final result:
Steps of the soltuion:
1.Add a custom column to return MonthYear based on the date column.
2.Group by the date column.
3.Add a custom to return the majority of the month year.
4.Fill down/up the monthyear.
5.Remove unneeded columns and expand the all rows, you will get the result.
You can also download my attachment for more details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi nic2023 ,
Raw data:
Final result:
Steps of the soltuion:
1.Add a custom column to return MonthYear based on the date column.
2.Group by the date column.
3.Add a custom to return the majority of the month year.
4.Fill down/up the monthyear.
5.Remove unneeded columns and expand the all rows, you will get the result.
You can also download my attachment for more details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen, Would you be able to elaborate more on the above step 5? How to 'expand all rows"?
5.Remove unneeded columns and expand the all rows
Thank you so much!
