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.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.