Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
CMSGuy
Helper III
Helper III

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]

CMSGuy_0-1659539514265.png

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 
1 ACCEPTED SOLUTION
daXtreme
Solution Sage
Solution Sage

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

View solution in original post

2 REPLIES 2
daXtreme
Solution Sage
Solution Sage

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

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.