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
arjuns0028
Helper I
Helper I

How to obtain the Running Sum of Enrollment

arjuns0028_0-1712204699005.png

Pls could you guide me in getting the Running Sum of Enrollment on the Y axis.

I want the output of the graph to in an exponential form. I have a column as Enrol_Count.
Pls do share the simplest solution and the method.

3 REPLIES 3
arjuns0028
Helper I
Helper I

How to keep all the data points if my data is in discrete form

Hi @arjuns0028 ,

Did it solve your problem?
Did my message help you in any way? If it did, please mark my message as the solution and give it a "kudo", I'll appreciate it and help me out

 





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




_AAndrade
Super User
Super User

Hi @arjuns0028,

Take a look at this simple example:

I have this table:

_AAndrade_0-1712214989514.png


I add this DAX measure:

RumSum Measure = 
VAR _Table = 
FILTER(
        ALL(T_RunSum),
        T_RunSum[Date] <= SELECTEDVALUE( T_RunSum[Date])
    )
VAR _Result = 
    SUMX(
        _Table,
        T_RunSum[Qty]
    )
RETURN
    _Result


And the final result is this:

_AAndrade_1-1712215116745.png


I hope this help you with your problem.





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.