Forum Discussion
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 = for...
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.
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.