Forum Discussion

Soldexio's avatar
Soldexio
Icon for Helper I rankHelper I
8 years ago
Solved

Flag row as used

Hey there,   I have a situation I have not been able to tackle without multiple merges and complicated solutions, which I believe can be done easier. Lets say I have the following example INVENTORY...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Soldexio,

     

    Based on test, you formula need  to do some Recursive calculation which power bi not support, so I'd like to suggest you calculate out of power bi and import result table to create visualization.

     

    Current steps: need one more condition to loop through previous calculated to ensure current amount not calculated in previous.

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Soldexio,

 

Based on test, you formula need  to do some Recursive calculation which power bi not support, so I'd like to suggest you calculate out of power bi and import result table to create visualization.

 

Current steps: need one more condition to loop through previous calculated to ensure current amount not calculated in previous.

 

 

Regards,

Xiaoxin Sheng

Soldexio's avatar
Soldexio
Icon for Helper I rankHelper I
8 years ago

Hi Anonymous

 

Thanks for the attempt, I came to the same conclusion and just wanted to make sure there was no trick underwater that could help me.

 

Kind regards,

 

Soldexio