Forum Discussion
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...
This looks like a GroupKind.Local type of problem.
See Chris Webb's blog or ehansalytics
Some kind of windowing function using lag and lead with partitions?
I know there is a technique where a pseudo- grouping column is created (You can probably use the ID2 column). I'm sure there's stuff out there on the web
Thanks - Will look into it! Unfortunately the ID2 column was a manual test column that I was trying to replicate with my DAX formula - not actually in the dataset!
