topic Re: Help with DAX function in DAX Commands and Tips

Help with DAX function

Anonymous — Wed, 18 Jan 2023 12:25:54 GMT

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?

Re: Help with DAX function

amitchandak — Wed, 18 Jan 2023 13:25:49 GMT

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.

Re: Help with DAX function

Anonymous — Wed, 18 Jan 2023 13:41:27 GMT

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.