Create a date table to using existing dataset “order date” column in power pivot

[ngocnguyen]

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!

[v-stephen-msft]

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.

[amitchandak]

@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