Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with DAX function

Dear,

 

I'm making a power BI set where i upload every half hour new information via excel. In essence it's a view of the current/open orders.

Green = picked orders

Red = open orders 

Blue = forecast

 

Now i would like to add a line which shows the new orders, it's basically the open + picked orders form the lastest meassurement - open + picked orders from the previous meassurement. Does anyone know how to do this?

 

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
    Appreciate your Kudos.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi amitchandak 

       

      Hopefully i can explain better with an example, please see the graph attached.

       

      at 09:00 there were 92 open orders and 64 picked orders = 92 + 64 = 158 total orders
      at 09:30 there were 94 open orders and 122 picked orders = 94 + 122 = 216 total orders

      This means that in this half hour there were 216 - 158 = 58 new orders generated. 

       

      Now i'm looking for a DAX formula that can do this calculated for me automatically for every interval.