cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Cumulatief measure

i need some help With a measure for a cumulative

i have a table like this:

date                 Discription                balance

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

4 REPLIES 4
Helper II

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
Not applicable

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
Super User

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
Not applicable

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