Summarize table based on column values

[fingalbrad]

Hi I have a spreadsheet which is set up as below. Its a list of notifications and the individual tasks associated with the notification and the individual completion dates. The tasks may be the same for the notifications, but they have different completion dates. 

Notification     Priority        Tasks       Task Compled Date

1                       2                   A            Completed  Date 

1                       2                   B             Completed Date 

2                       3                   A             Completed Date 

3                       3                   A             Completed Date

3                       3                   B             Completed Date

3                       3                   C             Completed Date

I want to Summarise this table to the following

Notification    Priority    Task A                         Task B                         Task C   

1                      2             Completed Date        Completed Date        Completed Date

2                      3             Completed Date        Completed Date        Completed Date

3                      3             Completed Date        Completed Date        Completed Date

[Ashish_Mathur]

Hi,

Create a matrix visual.  Drag the first 2 fields to the row labels and the third one to the column labels.  Write this measure

=MIN(Data[Task Completed Date])

Hope this helps.

[fingalbrad]

I want to do all this in the data part of powerbi. I want to create a new table before I do the visual

[Ashish_Mathur]

Hi,

Go to the Query Editor click on any cell in the Tasks column.  Under Transform, click on Pivot column.

[fingalbrad]

THanks for that. The only issue now is that I have the notification listed multiple time. I only wanted it listed once and have the dates shown

[Ashish_Mathur]

Share a proper example and show the expected result.

[danextian]

Hellow @fingalbrad ,

Have you tried using the matrix visual.  You can drag Notification and Priority columns to Rows, Tasks to Columns and Completed date to Value. If you want a layout very similar to yours, may disable the stepped layout and the subtotals. Once plotted, your data should looke like below:


More on the matrix visual: Create matrix visualizations in Power BI

[fingalbrad]

Hi 

I want to be able to do some analysis tho and compare the dates between the tasks. I dont think I can do this with a visual??