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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Keco5050
New Member

Cumulative Open Actions  Dax issues

I'm experiencing troubles with the syntax, which is right, but I want to be able to move values month by month, for example.

 

IF 

Jan as 5 values

feb as 0 values

March 2 values 

 

i want to see this result 
Jan with 5 values 

feb with 5 values 

March with 7 values 

 

i want to be able to see this kind of result but what i have with the dax before is different 

 

Jan ..5 values

March 7 values 

as you can see it leavng out the feb even thou as no Values i want to see the jan value move to the feb  i will greatful if i can find solution to this urgently

Cumulative Open Actions 

                      = VAR CurrentDate = MAX('Action Tracker'[Date of Action])

                      RETURN

                           SUMX( FILTER (
                                        ALLSELECTED('Action Tracker'[Date of Action]),                       

                                       'Action Tracker'[Date of Action] <= CurrentDate
                     ),
               CALCULATE(
                            COUNTROWS(
                               FILTER( '
                                       Action Tracker',
                                      'Action Tracker'[Current Status] = "Open"
                                   )
                            ),
                               ALLEXCEPT('Action Tracker', 'Action Tracker'[Date of Action])

                               )

)

1 REPLY 1
Dangar332
Super User
Super User

HI, @Keco5050 

 

as i understood  you can try below

here is my data

Dangar332_0-1698785572161.png

 

here out put as a measure

Dangar332_1-1698785608201.png

logic behind cumilative sum is below

 

result = 
CALCULATE(SUM(**bleep**[sales]),**bleep**[date]<=MAX(**bleep**[date]))

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. and don't forget to give kudos.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors