Forum Discussion
Power Query refreshing issue?
Hi, I try to estimate price variation on every item (article_id). I started with this https://hatfullofdata.blog/power-query-get-previous-row-data/. Everything goes well in Power Query but not wh...
Hi lambrosx
in the Join statement (line 16 of your PQ statements), you are using also the fields "Client" and "Reference" for the join, which we cannot see in your screenshot.
So maybe there is no match for this field combination for the other articles?
Hi Martin_Weiss, thank you for the answer.
I didn't put those columns for confidentiality but they are well filled.
It's only the column "PU" after joining indexes and the calculated one that are empty after few lines.
I can't explain why everything is ok in Power Bi et not in excel.