Forum Discussion
Fuzzy Grouping
Data Groups are done in the model, not in Power Query or source data.
If you wanted to group them in at Dataflow, you'd need to create a conditional column that would add the right grouping as another column.
if [field] = "Boston's Children" then "Harvard Med"
else if [field] = "something else" then "Harvard Public Health"
and so on.
I'd argue the conditional column is the better way from a modeling standpoint to approach it, but it is more tedious than data grouping drag and drop.
Data Groups are done in the model, not in Power Query or source data.
If you wanted to group them in at Dataflow, you'd need to create a conditional column that would add the right grouping as another column.
if [field] = "Boston's Children" then "Harvard Med"
else if [field] = "something else" then "Harvard Public Health"
and so on.
I'd argue the conditional column is the better way from a modeling standpoint to approach it, but it is more tedious than data grouping drag and drop.
Yeah I'm not sure either one of these options is feasible the list of accounts contains roughly 500k rows. Maybe I am better off using the built in ML modules to try and group the accounts, I've done at least a few thousand manually already that I could use as a potential training model.
