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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
LD
Frequent Visitor

Issue on Cumulative Sum

Dear All,

please, I have the following Dataset and I would like to measure the cumulative sum by month of [YTD_in/out]_

 

LD_1-1656000496329.png

 

I try the following structure:

Var LastM = SELECTEDVALUE('Y Projection'[Month])

Var Dep = SELECTEDVALUE('Y Projection'[Department])
Return
CALCULATE(
SUM('Y Projection'[YTD_IN/OUT]),
'Y Projection'[Month]<=LastM && 'Y Projection'[Department]=Dep

 

but the Column [Colonna] didn't show any results, but any error too.

 

Please, How I can Solve?

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

@LD 

Please use

=
VAR LastM = 'Y Projection'[Month]
VAR CurrentDepTable =
    CALCULATETABLE (
        'Y Projection',
        ALLEXCEPT ( 'Y Projection', 'Y Projection'[Department] )
    )
RETURN
    SUMX (
        FILTER ( CurrentDepTable, 'Y Projection'[Month] <= LastM ),
        'Y Projection'[YTD_IN/OUT]
    )

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

@LD 

Please use

=
VAR LastM = 'Y Projection'[Month]
VAR CurrentDepTable =
    CALCULATETABLE (
        'Y Projection',
        ALLEXCEPT ( 'Y Projection', 'Y Projection'[Department] )
    )
RETURN
    SUMX (
        FILTER ( CurrentDepTable, 'Y Projection'[Month] <= LastM ),
        'Y Projection'[YTD_IN/OUT]
    )
LD
Frequent Visitor

Thank You Tamerj1,

It's fine and the value are exact!!!!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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