Bernat Agulló on 28 Jan 2022 14:22:22
It is often the case I have a big fat table and I am trying to model it in a few dimensions.
To do that I create a reference to the query, select the customer ID along with all the attributes of the customer and then remove duplicates by customer id.
This process could be automated with a few clicks and a warning when one or more of the attributes selected are not constant for a single key value
It could offer to create a new query also refrencing the same fact table but with the attribute columns already removed. And maybe even set the original query to disable load to the model!
that would be very convenient when doing this sort of task.
I discussed about it in tweeter Bernat Agulló en Twitter: "It would be cool a "create dimension from columns" option in powerquery, asking for your key column and checking that the rest (attributes) are indeed constant for the same key before using key column to remove duplicates" / Twitter