cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gonzamau Frequent Visitor
Frequent Visitor

Cummulative DAX

Hi everyone

 

Someone can help me.... I try to do a DAX formula to calculate the cummulative figure per date and I cann't.... y try with this formula:

 

Cummulative Figure = CALCULATE(SUM(Applications[2018]); FILTER(all(Applications); Applications[2018] = LASTDATE(Applications[Date])); values (Applications[2018]))
 
Screenshot - 19_08_2019 , 2_13_23 p_ m.png
 

Thanks for the help

 

1 ACCEPTED SOLUTION

Accepted Solutions
buffanut Regular Visitor
Regular Visitor

Re: Cummulative DAX

Sorry, it would be either >= or <=. Try both of those. 

View solution in original post

3 REPLIES 3
buffanut Regular Visitor
Regular Visitor

Re: Cummulative DAX

change '=' to '=>' and see if that works. 

gonzamau Frequent Visitor
Frequent Visitor

Re: Cummulative DAX

Dear @buffanut Thx for the answer, nut it doesn't work...

 

Screenshot - 19_08_2019 , 3_01_26 p_ m.pngI only change the name of the column...

 

 

buffanut Regular Visitor
Regular Visitor

Re: Cummulative DAX

Sorry, it would be either >= or <=. Try both of those. 

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,253)