Skip to main content
cancel
Showing results for 
Search instead 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

Reply
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        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

4 REPLIES 4
GuillaumePower
Helper II
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 
FreemanZ
Super User
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:

FreemanZ_0-1683727580918.png

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.