Forum Discussion

mostvp123's avatar
mostvp123
Kudo Collector
4 years ago
Solved

Need Help - How to replicate a DAX formula using ALLEXCEPT in Power Query to minimise data load

I'm trying to replicate a DAX formula in Power Query M but struggling a bit. The reason for this exercise is we would prefer to minimise the data pulled into the model. Basically, my company is track...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    This looks like a GroupKind.Local type of problem.

    See Chris Webb's blog or ehansalytics

HotChilli's avatar
HotChilli
Community Champion
4 years ago

This looks like a GroupKind.Local type of problem.

See Chris Webb's blog or ehansalytics

mostvp123's avatar
mostvp123
Kudo Collector
4 years ago

One question though - any idea how one would one achieve something similar with T-SQL and a Group By statement?