Calculate Queue Size in Power BI

Question

Hi all,I am having a mind blank for a relatively simple calculated column in Power BI.&nbsp; I am trying to clculate the queue size, defined by:week_num&nbsp; &nbsp;hub_referrals&nbsp; &nbsp; starts&nbsp; &nbsp; Queue2021-41&nbsp; &nbsp; &nbsp; &nbsp; 17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(hub_referrals - starts) + previous Queue = (17 - 0) + 0 = 172021-42&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(hub_referrals - starts) + previous Queue = (17 - 18) + 17 = 162021-43&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(hub_referrals - starts) + previous Queue = (14 - 22) + 16 = 8......&nbsp;I have tried creating an index column then using that to get the value fo the previous row, then addign it to my formula, but it is not working dynamically.&nbsp; Any pointers on topics I should look at, or previous solutions I coudl draw inspiration from.&nbsp;&nbsp;thanksGareth

wdx223_daniel · Accepted Answer

a calculated column in dax:
newcolumn=sumx(filter(table,table[week_num]&lt;=earlier(table[week_num])),table[hub_referrals]-table[starts])
&nbsp;
M code in Power Query:
NewStep=Table.FromRecords(List.Accumulate(Table.ToRecords(PreviousStepName),{{},0},(x,y)=&gt;{x{0}&amp;{y&amp;[Queue=y[hub_referrals]-y[starts]+x{1}]},&nbsp;y[hub_referrals]-y[starts]+x{1}}){0})

Forum Discussion

Calculate Queue Size in Power BI

2 Replies

Related content

UK South Excessive queueing of pipeline activities

Excessive queueing of pipeline activities

How to calculate Average Queue Time

Configuring queue in Fabric

Power Query or Calculated columns