Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

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) ...
bhelou's avatar
bhelou
Icon for Responsive Resident rankResponsive Resident
3 years ago

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 




Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

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.