Forum Discussion
Create a date table to using existing dataset “order date” column in power pivot
Hi all I have 1 table that contain date column ( Order date ). Now I wanna create a date table to using existing dataset “order date” column in power pivot. I know how to create it in power bi, ...
ngocnguyen , You can create a calendar in power query like
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Not sure what you mean by using order date.
Maybe you create a table of distinct values , refer this video - https://youtu.be/kU2M1LmNvNo?t=65