Forum Discussion
Date as a Value
The expected output looks kind of non-standard in my opinion. However you could follow the attached pbix to get it. You will duplicate one column and pivot twice in this case.
I am able to add the score column since there are numbers but i cant add date column because it will count it.
To avoid counting, you can apply another aggregate function like MAX or even not aggregated.
Microsoft Employee
The expected output looks kind of non-standard in my opinion. However you could follow the attached pbix to get it. You will duplicate one column and pivot twice in this case.
I am able to add the score column since there are numbers but i cant add date column because it will count it.
To avoid counting, you can apply another aggregate function like MAX or even not aggregated.