Forum Discussion

gedwards1988's avatar
gedwards1988
Frequent Visitor
4 years ago
Solved

Calculate Queue Size in Power BI

Hi all, I am having a mind blank for a relatively simple calculated column in Power BI.  I am trying to clculate the queue size, defined by: week_num   hub_referrals    starts    Queue 2021-41    ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    a calculated column in dax:

    newcolumn=sumx(filter(table,table[week_num]<=earlier(table[week_num])),table[hub_referrals]-table[starts])

     

    M code in Power Query:

    NewStep=Table.FromRecords(List.Accumulate(Table.ToRecords(PreviousStepName),{{},0},(x,y)=>{x{0}&{y&[Queue=y[hub_referrals]-y[starts]+x{1}]}, y[hub_referrals]-y[starts]+x{1}}){0})

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

a calculated column in dax:

newcolumn=sumx(filter(table,table[week_num]<=earlier(table[week_num])),table[hub_referrals]-table[starts])

 

M code in Power Query:

NewStep=Table.FromRecords(List.Accumulate(Table.ToRecords(PreviousStepName),{{},0},(x,y)=>{x{0}&{y&[Queue=y[hub_referrals]-y[starts]+x{1}]}, y[hub_referrals]-y[starts]+x{1}}){0})

gedwards1988's avatar
gedwards1988
Frequent Visitor
4 years ago

Thanks this worked a treat, slight error in my formul and M code but now works perfectly.  Thanks