Power BI Exchange

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

View My Drafts

Back to discussions
Expand all | Collapse all

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
    ------------------------------