Forum Discussion
Pivot creates duplicate values
Hi labuser1235 ,
Remove the FID column and pivot Fname column with Fdata as value column should work.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi labuser1235 ,
I don't think without edit query transactions if you can get a new table.
If in case you don't want a new table, you can use MATRIX visual,
On matrix visual, you can have TID on Row section, FName under Column section and your summarised metric under VALUE section.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Pragati11 I donot want to use matrix visual... I would like the output to get achieved in table visual as I am also clubing it with another data from another tables.
I would like to get that achieved as an output with the help of transformaitons using power query or calculated columns,so that I can use in table visual.
Hi labuser1235 ,
In that case try replacing null values in TID column with a value like "Unknown ID" or "ID Missing".
Then try the usual pivot steps in query editor.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati