Create summary project table from raw data

[AgencyPowerBi]

Hi,

I need help building summary project table from raw data, so I can construct gantt chart.

So what I need to do is to summarize table with only DATE column and to end up with summary table grouped by PRODUCT and START_DATE and END_DATE, and some other aggregates.

START and END should summarize all data in sequential dates.. so if there is data for 1st, 2nd and 5th of January, it should groupe product from 1.1. till 2.1. and another row for only 5th.

I tried doing it alone, it proved a challenge, and it was harder still with unsorted data.

Please help, 

Ante

[AgencyPowerBi]

Thank you for the reply, 

How can I add date columns? Do you have and example?

[Idrissshatila]

Hello @AgencyPowerBi ,

try using the group by function in power query.

check this link https://learn.microsoft.com/en-us/power-query/group-by

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin