Forum Discussion
Summarize table based on column values
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 ...
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.
I want to do all this in the data part of powerbi. I want to create a new table before I do the visual
Hi,
Go to the Query Editor click on any cell in the Tasks column. Under Transform, click on Pivot column.
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
