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, but in power pivot, I don't know.
Could you please show me how to do it?
Many thanks in advance for your support!
2 Replies
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
Hi ngocnguyen ,
Does your Power Pivot refer to Power Query?
You can try to create a calculated table in Power Query as
Calendar table = CALENDAR(MIN('Table'[Order date]),MAX('Table'[Order date]))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.
