Forum Discussion

mostvp123's avatar
mostvp123
Icon for Kudo Collector rankKudo 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
Icon for Community Champion rankCommunity Champion
4 years ago

This looks like a GroupKind.Local type of problem.

See Chris Webb's blog or ehansalytics

mostvp123's avatar
mostvp123
Icon for Kudo Collector rankKudo Collector
4 years ago

Wow! That worked 😄 Thank you so much!! What a neat trick!