Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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    
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    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.

     

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

     

    I trust you are doing well.

     

    Please have a look at the below screenshots:

     

     

    Please mark as answer if correct :)

    Kind Regards

    Bash

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous,

         

        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