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

Cumulative Values row wise and with date filter minimum and maximum

Hi Folks,
I need help in calculating the cumulative frequencies row wise with minimum date and maximum date selection by users using sliders. Here is the table that i want to generate could you please guid me ? I've tried various function and methods but nothing is giving me right answer. Thanks a lot in advance.
Below is the table that i've and i want to generate,

 

IDDatevalues
115-08-1912
216-08-1915
317-08-1948
418-08-1965
519-08-1994
620-08-195
721-08-1926
822-08-1945
923-08-1959
1024-08-1936
1125-08-1921
1226-08-195
1327-08-1942

 

 

IDDatevaluesCumulative Values row wise  Date Slider
115-08-1912    
216-08-1915  From17-08-19
317-08-194848   
418-08-1965113 To25-08-19
519-08-1994207   
620-08-195212   
721-08-1926238   
822-08-1945283   
923-08-1959342   
1024-08-1936378   
1125-08-1921399   
1226-08-195    
1327-08-1942    
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Cumulative Values row wise and with date filter minimum and maximum

Hi @GaneshAB100 ,

 

You could use this mesure. You also need a Product slicer and a Date slicer.

Measure 2 =
CALCULATE (
    SUM ( test[value] ),
    FILTER ( ALLSELECTED ( test ), test[ID] <= MAX ( test[ID] ) )
)

Here is the result.

2-1.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Bash Regular Visitor
Regular Visitor

Re: Cumulative Values row wise and with date filter minimum and maximum

Hi @GaneshAB100,

 

I trust you are doing well.

 

Please have a look at the below screenshots:

 

Capture.PNGCapture 2.PNG

 

Please mark as answer if correct 🙂

Kind Regards

Bash

GaneshAB100 Frequent Visitor
Frequent Visitor

Re: Cumulative Values row wise and with date filter minimum and maximum

Hi,

 

Thanks for your reply. I have gone throgh the solution and screenshot & replicated it in my soultion. But, it is not giving me expected results. When i am sliding up and down the dates it is disturbing the result. Can we use somehow min date and max date which is from slider in the same query to compute the results ? I tried multiple queries but not getting correct answer.

Bash Regular Visitor
Regular Visitor

Re: Cumulative Values row wise and with date filter minimum and maximum

Hi @GaneshAB100,

 

Im not sure why its not working since i have duplicated the information you gave and placed it into an excel spreadsheet and got the desired amounts that you posted.

 

Could you elaborate abit more on the issue?

Are all these fields in one table ? 

Can you show me your formula?

 

Kind Regards

Bash

 

Bash Regular Visitor
Regular Visitor

Re: Cumulative Values row wise and with date filter minimum and maximum

Try creating a quick measure- Running total - Base value would be your value field - the other value would be your ID field - leave the asceding as is.

GaneshAB100 Frequent Visitor
Frequent Visitor

Re: Cumulative Values row wise and with date filter minimum and maximum

Hi,

 

Ok, I will try it and share the query with you. Allow me some time.

GaneshAB100 Frequent Visitor
Frequent Visitor

Re: Cumulative Values row wise and with date filter minimum and maximum

Here is the complete table and includes all the avriables, 

 

in the dashboard we have one filter for Product and one slider for date. Using both i am calculating cumulative sum.

 

IDProductDateValueCumSum  Filter for Product Slider for Date 
           
1A26-Sep5  AChoosed 28-SepFrom
2A27-Sep6  B    
3A28-Sep99 C  3-OctTo
4A29-Sep817      
5A30-Sep7491      
6A1-Oct596      
7A2-Oct6102      
8A3-Oct8110      
9A4-Oct2       
10A5-Oct2       
11B26-Sep6       
12B27-Sep9       
13B28-Sep8       
14B29-Sep6       
15B30-Sep3       
16B1-Oct2       
17C26-Sep5       
18C27-Sep9       
19C28-Sep8       
20C29-Sep4       
21C30-Sep2       
22C1-Oct36       
           
Community Support Team
Community Support Team

Re: Cumulative Values row wise and with date filter minimum and maximum

Hi @GaneshAB100 ,

 

You could use this mesure. You also need a Product slicer and a Date slicer.

Measure 2 =
CALCULATE (
    SUM ( test[value] ),
    FILTER ( ALLSELECTED ( test ), test[ID] <= MAX ( test[ID] ) )
)

Here is the result.

2-1.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

GaneshAB100 Frequent Visitor
Frequent Visitor

Re: Cumulative Values row wise and with date filter minimum and maximum

Hi,

 

Thanks for your reply. This solution is giving me the results.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 305 members 3,098 guests
Please welcome our newest community members: