Forum Discussion
Solved
Date as a Value
Hi, I am trying to make a report where I have a Subject a score and the date of the test, So, I have my table Subject_test: Studentid SubjectID Subject Score Dateoftest what I want to do...
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.
Greg_Deckler
Community Champion
Community ChampionCan you post some sample data?