Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cyclic reference when calculating a Stock using its previous day result

Hello,   I have a problem with a cyclic reference  trying to calculate the stock of a final inspection process.       *Day stock is the result of Production - Scrap - Wharehouse ent...
Need Help
dax's avatar
dax
Community Support
6 years ago

Hi RamiroDiz, 

I think it is hard to calculate cycle reference in DAX. You need to create many measures for the previous day's value and the meausre will be beased on context, so it is hrad to get previous day's value(I complete a part of this). You might need to achieve this in other tools, then use this in PowerBI. Or you could try to ask other super users in forum for help.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    It's not posible to create infinite measures to get the value im wishing because I don't know how many days will pass since the last inventory.
    Thats why I'm trying to generate a calculated column that brings the previous Day Stock if Inventory is empty. But I'm not able to get what I need.

    Thanks for the answer,
    Ramiro