Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have done pivot column for the table in the first image for column session type. In the result for date 01/07/2001 the result is showing incorrect sum for the column rating 'comm' . What might be the reason ? This is the mQuery used.
= Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[#"Session Type"]), "Session Type", "Sessions", List.Sum)
@mdsmith1
Solved! Go to Solution.
Hi @sangeethray,
Pivoting does not summarise the rest of the column, rather it groups it.
If you want to retain similar numbers (to be able to summ them later) you can add an index column before pivoting. This will preserve all rows.
Cheers,
John
Hi @sangeethray,
Pivoting does not summarise the rest of the column, rather it groups it.
If you want to retain similar numbers (to be able to summ them later) you can add an index column before pivoting. This will preserve all rows.
Cheers,
John
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.