Forum Discussion
#REF error after Power Query refresh
A power query + data model + power pivot solution can also be considered by creating relationships from supplier table and product table as dim tables (lookup tables) to the parameter/calc table (fact table) then, display the results into a power pivot especially if supplier/product calculation is high volume would be most efficient.
Yea_So Well, kind of. I don't really like stuff that doesn't work and then magically starts to work, doesn't give me a lot of confidence... But, yes, short term, the problem seems to have disappeared...
I know that feeling, you can try a different angle, instead of adding columns to the power query resultant, you can create a table where the user will input the parameter values and do a SUMIF power query style:
https://youtu.be/twgcfuJx1sU
- OK, thank you!
