Solved: Get dates

jhk3 · ‎08-14-2022

Hey guys! I have two columns: one is ship date year (2021 or 2022) and the other is ship date month (1-12). How can I combine these two in the power query editor? I do not have the day recorded just month and year. all the formules i find online have format which it says it doesn't recognize. Thanks!

mahoneypat · ‎08-14-2022

Assuming the year and month columns are type integer, you can use this expression to generate the 1st of each month. You can then convert it to date type and relate it to your Date table, etc.

= #date([ShipDateYear], [ShipDateMonth], 1)

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎08-14-2022

Assuming the year and month columns are type integer, you can use this expression to generate the 1st of each month. You can then convert it to date type and relate it to your Date table, etc.

= #date([ShipDateYear], [ShipDateMonth], 1)

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube