Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Budgeting visual in Power bi

Hi, I'm relatively new to the Power bi scene but feel I'm picking things up quite fast.

I'm trying to create a budgeting visual that shows the depreciation of the budget over months.

Budget = $5,000

Expenses =

Jan = $100

Feb = $200

Mar = $100

So on the graph it should show:

Jan = $4900

Feb = $4700

Mar = $4600

Any thoughts on how I could go about this?

P.S. The expenses are calculated by a measure

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , You have to create a cumulative measure of actual and subtract from Budget

    Like

    new measure
    =var _bud =5000
    return
    _bud- CALCULATE(SUM(Table[Actual]),filter(date,date[date] <=max(Table[Date])))

     

    Use date table.