Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a project dashboard I am setting up and i am struggling to get start and end dates on 1 row.
Below is a simpified version of my issue where I have mutliple lines for the same task;
Task Start date End Date
ABC | 1/07/2021 | 31/07/2021 |
ABC | 1/08/2021 | 31/08/2021 |
ABC | 1/09/2021 | 30/09/2021 |
ABCD | 1/09/2021 | 30/09/2021 |
What I would like to achive is having one line per task, something more inline the table below
TASK | START DATE | END DATE |
ABC | 1/07/2021 | 30/09/2021 |
ABCD | 1/09/2021 | 30/09/2021 |
How do I achieve this in Power query?
Thanks In advance
Solved! Go to Solution.
You can use the Group By feature in the query editor. Group by the Task column and then add two aggregations with the min of the Start date column and max of the End date column.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
So simple i didn't even think of that, works like a charm. Thank you @mahoneypat
You can use the Group By feature in the query editor. Group by the Task column and then add two aggregations with the min of the Start date column and max of the End date column.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |