Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cumulative stacked bar chart (date/amount)

Hi everyone   I try to cumulate amounts over different years (taking into account the steps, see example below) with stacked histograms. Stacking works well for years, but when I want to view it...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a measure like


calculate(sum(Table[amount]), filter(Allselected(Table), Table[Date] = max(Table[DAte]) && Table[account] = max(Table[account])))

 

or


calculate(sum(Table[amount]), filter(Allselected(Table), Table[year] = max(Table[year]) && Table[account] = max(Table[account])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Amitchandak,

    Thanks for your answer.
    How can I use your formula in power bi? because there are several '='

     

    thanks in advance