Forum Discussion
Self-referencing calculated column
Hello! In PowerBI I have loaded a spreadsheet with historical records of a factory. It contains the following columns: SKU Date Demand Real Physical Stock (SFR) Stock in real transit (STR) ...
Check this if it works :
IF([Day Number] < 1, [Real Physical Stock (SFR)],
IF([Day Number] = 1, [Real Physical Stock (SFR)] + [Fictitious entry (EF)] - [Demand],
LAG([Fictitious Physical Stock (SFF)],1) + [Fictitious entry (EF)] - [Demand]))
if it is solved kindly accept as a solution .
Thanks
Thank you very much for the reply.
This possible solution would not be working for me, since it does not recognize the GAL function, nor the SFF value within this function:
Best regards.