Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
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.
@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
User | Count |
---|---|
84 | |
79 | |
69 | |
46 | |
43 |
User | Count |
---|---|
106 | |
50 | |
49 | |
40 | |
39 |