topic Re: Cumulatief measure in DAX Commands and Tips

Cumulatief measure

Anonymous — Wed, 10 May 2023 13:51:24 GMT

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

Re: Cumulatief measure

FreemanZ — Wed, 10 May 2023 14:06:38 GMT

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?

Re: Cumulatief measure

GuillaumePower — Wed, 10 May 2023 14:08:59 GMT

Something like that, try and say if it works.

CALCULATE(

SUM(table[balance],

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

)

Re: Cumulatief measure

Anonymous — Wed, 10 May 2023 14:11:48 GMT

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

Re: Cumulatief measure

Anonymous — Wed, 10 May 2023 14:21:23 GMT

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