Cumulatief measure

[Anonymous]

i need some help With a measure for a cumulative 

i have a table like this:

date                 Discription                balance

01-01-22        kbkadjbsakjdb             25,00

01-01-22        jfdjksdjlksdfnh              50,00

01-01-22       lkjsdffnjksdf                   -70,00

02-01-22        lsjkdnflk                        30,00

03-01-22         jsjkzf                             -33,85

03-01-22         lknslkdf                         40,00

04-01-22         lkdfsnlksdf                    80,00

i have a relation with a calender table to my fact table 

many thaks

[GuillaumePower]

Something like that, try and say if it works.

CALCULATE(

       SUM(table[balance],

       DATESBETWEEN(CALENDAR[DateKey],date(2022,1,1),date(2021,1,1)

)

[Anonymous]

that does'nt work  if used this measure without the breakdown: 

Cumulative Revenue =

VAR EarliestDate = CALCULATE(MIN(Kalender[dd-MMM]),ALLSELECTED())

RETURN CALCULATE([saldo huidig jaar],FILTER(ALL(Kalender[dd-MMM]),'Kalender'[dd-MMM] <= MAX('Kalender'[dd-MMM]) && 'Kalender'[dd-MMM] >= EarliestDate))

but i need another table with the breakdown on discription the measure above is without discription and that works but if i add the discription to the tabel that measure wont work anymore and it only does the sum 

[FreemanZ]

hi @Anonymous 

supposing your want to add up on date, try to plot a visual with date column and a measure like:

measure = 
CALCULATE(
    SUM(data[balance]),
    data[date]<=MAX(data[date])
)

it worked like:

it that so?

[Anonymous]

I need al the data in the tabel that i made in my exmaple i already have the measure for cumulative on date but i need another one for the breakdown on discription base. because of the breakdown i could have thee same day multiple times