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

    • 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