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,


Can you please provide some sample data or pbix file for test? It will be help to clarify your table structure and coding formula.


Regards,

Xiaoxin Sheng

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

Hey there,

 

In the first post I have given some sample data to clarify my table structure and coding formula. The situation is that I have 2 tables with a few colums. Is that not enough?

 

Kind regards,

 

Dennis