Forum Discussion

ngocnguyen's avatar
ngocnguyen
Icon for Helper IV rankHelper IV
5 years ago

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, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.