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