Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Running Total BUT starting with a baseline amount

  • 1.  Running Total BUT starting with a baseline amount

    Posted 24 days ago

    Hi,

    Due to our model not holding all the period data (for a full running total measure), i am attempting to cobble together 2 'facts' and need your help!

    What i am attempting is (to use for an s-curve line chart);

    If a slicer was selected at say Period 5

    'To Date' at Period 5 + 'Period Value' Running Total from Period 6 onwards

    Example data below...

    Period To Date Period Value
    1 6500 0
    2 7500 1000
    3 8500 1000
    4 9500 1000
    5 11500 2000
    6 12500 1000
    7 12500 0
    8 12500 0
    9 13500 1000
    10 14500 1000
    11 15500 1000
    12 16000 500



    Any help appriciated




    Neil



    ------------------------------
    Neil Arnold
    Senior Business Analyst
    Networkrail
    7515626363
    ------------------------------