Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate consecutive backlogs over a specific threshold value.

I have a sample data table with given Columns A, B and E. Need to calculate Columns C and D as outputs in Power BI and use Col D in Histogram. Giving a Cyclic reference error as it needs to calculate...
  • smpa01's avatar
    smpa01
    3 years ago

    Anonymous  you can write a measure like this

    Measure =
CALCULATE (
    [dropPlusRollOver],
    OFFSET ( -1, DISTINCT ( ALL ( 'fact' ) ), ORDERBY ( 'fact'[Date], ASC ) )
)
    + MAX ( 'fact'[Drop] )

     

    PFA

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous  you can write a measure like this

Measure =
CALCULATE (
    [dropPlusRollOver],
    OFFSET ( -1, DISTINCT ( ALL ( 'fact' ) ), ORDERBY ( 'fact'[Date], ASC ) )
)
    + MAX ( 'fact'[Drop] )

 

PFA

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for the response but Column C and Column D have to be output using Column A and Column B and a capacity parameter. i think you used them as input for measures. 

    Also i need to sho highlighted Column D in a histogram visual.

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Anonymous  this is a good place to start