Forum Discussion
EdJ
5 years agoNew Member
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
- amitchandak
Super User
EdJ , sum of bank balances per last day is a measure. You need to consider binning or segmentation using an independent table
refer
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualizationMy video: https://www.youtube.com/watch?v=CuczXPj0N-k
- AnonymousNot applicable