Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Krijgerss21
Helper II
Helper II

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
Frequent Visitor

Something like that, try and say if it works.

CALCULATE(

       SUM(table[balance],

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

)

 

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 @Krijgerss21 

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?

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors