Hi, I'm looking for a formula to calculate a Total of an Indicator excluding dimension of time.
I have a table that shows a Balance today for each Costumer and I make a Drill-Down see the correspondent bill. I need to see the sum of charges and the payments for this each Bill.
Go to Solution.
This is the Final Formula
Cumulative Cargos = CALCULATE ( SUM ( 'Indicadores Cartera'[Cargo] ), FILTER ( ALL( 'Cat Tiempo'[Fecha] ),'Cat Tiempo'[Fecha]<= MAX ('Cat Tiempo'[Fecha])))
I had problems with the data but not because the formula.
I can't find how to calculate the sum of charges and the payments for this each Bill.
Could you give more detailed information?
Ok, This is an Example
I need always the Sum of The Charge for the Correspondent Bill
The same for the Payments (for the correspondent bill)
I want to exclude the date for the sum of Charges and Payments , of course I need Charges and Payments for the correspondent Bill.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.