Forum Discussion

FawadRehman's avatar
FawadRehman
Helper I
10 years ago
Solved

Running Total - DAX

I need help. I am looking for same solution http://community.powerbi.com/t5/Desktop/DAX-Running-total-by-another-column/m-p/10512#M2189 but somehow its not working for me.    RunningTotal...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    FawadRehman This should work... Let me know.

     

    Running Total COLUMN =
CALCULATE (
    SUM ( TabelForecast[Forecast] ),
    ALLEXCEPT ( TabelForecast, TabelForecast[M#] ),
    TabelForecast[MonthYear] <= EARLIER ( TabelForecast[MonthYear] )
)
Sean's avatar
Sean
Community Champion
10 years ago

FawadRehman This should work... Let me know.

 

Running Total COLUMN =
CALCULATE (
    SUM ( TabelForecast[Forecast] ),
    ALLEXCEPT ( TabelForecast, TabelForecast[M#] ),
    TabelForecast[MonthYear] <= EARLIER ( TabelForecast[MonthYear] )
)
  • FawadRehman's avatar
    FawadRehman
    Helper I
    10 years ago

    Working like a charm. Thank You. btw do you know line break in text box? 

  • FawadRehman's avatar
    FawadRehman
    Helper I
    10 years ago

    Here is my lookup column code

     

    Full Contact = LOOKUPVALUE(' Contacts'[Manager Name],' Contacts'[Id],'Customer Contact'[ ContactId])
    & "i want line break here " & LOOKUPVALUE(' Contacts'[Email],' Contacts'[Id],'Customer Contact'[ ContactId])
    & "i want line break here " & LOOKUPVALUE(' Contacts'[Telephone],' Contacts'[Id],'Customer Contact'[ ContactId])

     

     

    output

    John Doe

    [email protected]

    123-345-5677

     

    Thanks

  • Lucy64's avatar
    Lucy64
    Advocate II
    10 years ago

    Can I calculate a running total without a date field.  I have a list of Machine Names and production total for each machine.  With the production total showing in descending order I want to add a running total from highest to lowest.  Data is from SQL database with a direct link.  Please let me know if this is possible.  The idea is when I drill down or filter the calculation of the running total will recalculate based on data showing.