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.
Morning all
As context I have used the group by and pivot transformations to summarise which tracks responses to a survey. My issue arises when a particular column is not constant, for example the column is called 'request ruling' once this request has been actioned by staff the value becomes something else in the dataset.
This vanishing column gives me a refresh error in the service, stating that column doesnt exist.
my question is there a way using grouo by and transform that i get get these request ruling column to stay.
thanks
James
Solved! Go to Solution.
For the pivot step, replace List.Distinct(...) with {"Value1", "Value2", "Value3", ...}
Replacing each "ValueN" with your values.
Alternativly, you can manually insert any that you are missing by replacing List.Distinct(...) with List.Distinct(... & {"MissingValue1", "MissingValue2", ...})
For the pivot step, replace List.Distinct(...) with {"Value1", "Value2", "Value3", ...}
Replacing each "ValueN" with your values.
Alternativly, you can manually insert any that you are missing by replacing List.Distinct(...) with List.Distinct(... & {"MissingValue1", "MissingValue2", ...})
Legend thank you
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.