Forum Discussion

CMSGuy's avatar
CMSGuy
Helper III
4 years ago
Solved

Cumulate Remainer formula help needed

I think this is pretty simple but I need help with a cumulative remainder total.  The table has a column, T1N which is total needed, then T1S is total submitted, then T1R is remainder.  This view is by Month right now but should be able to be drilled up to Quarter, then Year, or down by date.  The formula I have for T1R is currently this, which I am sure is not correct: 

T1R = 'Daily Certification Full'[T1N] - 'Daily Certification Full'[T1S]

Thanks for any help you can give

 

EDIT

 

This is from excel, but something I am looking for:

MonthNeededRecordedRemaining
May60456
June561838
July38236
August36036
Total 24 
Need Help
  • daXtreme's avatar
    daXtreme
    4 years ago

    CMSGuy 

     

    Are these Txx measures or columns from the base table? If they are measures, then I guess it's enough to turn them into: T1N = SUM( T[RelevantColumn] ). Same for T1S and then T1R will be the diff of the measures.

2 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage
    4 years ago

    CMSGuy 

     

    Are these Txx measures or columns from the base table? If they are measures, then I guess it's enough to turn them into: T1N = SUM( T[RelevantColumn] ). Same for T1S and then T1R will be the diff of the measures.

    • CMSGuy's avatar
      CMSGuy
      Helper III
      4 years ago

      They are coming from the base table.  Should they be measures?