Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |