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.
I would be grateful for any assistance with my latest challenge in PowerBI/PowerQuery
I have a table that records engineer recurring activities on a single row with a start and end date .....
I need to extrapolate these to another table with one row per engineer per day per activity, like so ...
I've been struggling with this for days ...
Thanks
Solved! Go to Solution.
Thank for the reply. In the end I actualy resolved this ... I discovered CROSSJOIN and CALENDER and used these to dynamically create the new table in DAX
Hi Pcav
You could try adding an extra column in the Query Editor using this formulae:
Table.AddColumn(#"Previous Step","Date", each {Number.From([StartDate])..Number.From([EndDate])})
That will create a list of all the dates between your start and end (inclusive). You can then expand the column out using the little icon in it's header and it'll create a row per person per day. Once you've expended the Date column out you'll need to format it as a date otherwise it'll look like a bunch of numbers - those numbers are actually date codes.
Thank for the reply. In the end I actualy resolved this ... I discovered CROSSJOIN and CALENDER and used these to dynamically create the new table in DAX
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |