Forum Discussion

EdJ's avatar
EdJ
New Member
5 years ago

calculation sum per day per administration

Hi, I have an issue I'm trying to work through. 

 

I have a list which is updated daily of bank balances, with numerous bank accounts of multiple administrations.

I have made a new table to calculate the sum of amount per day per administration. 

Berekeningen = SUMMARIZECOLUMNS(  Dagsaldo[Datum_bankafschrift], Dagsaldo[administratienaam],  "Sum of Amount",SUM(Dagsaldo[Dagsaldo per bankrekening]) )
 
 
Q1: visual line dot
I have a visual line dot with daily bank balances including a drop down select filter by administraton: works ok. But I would like to ad the sum of bank balances per day which also filters when selecting one or multiple administrations.
 
Q2: calculation
For a simple calculation I need the sum of bank balances per last day which also filters when selecting one or multiple administrations by drop down select filter.

2 Replies