Forum Discussion

datadax123's avatar
datadax123
Regular Visitor
2 years ago

Cumulative Sum - 2 conditions

Hey everyone !   I have done many tests here but can't find any solution, any help is appreciated.   I have a complex dashboard but I simplified it here in order to focus on the issue :   I hav...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi datadax123 ,

I would appreciate it if you could give me the expected results, thank you.

Best Regards,

Xianda Tang

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

datadax123's avatar
datadax123
Regular Visitor
2 years ago

Hey Anonymous ,

In this example it would be : 

Sales StartQuantity
0 
13
2 
3 
4 
5 
6 
7 
8 
9 
10 
111
122
13 
20 
27 
34 
412



  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi datadax123 ,

    Below is my table1:

    Below is my table2:

    Below is my table3:

    The following DAX might work for you:

    Measure = 
   var _sale = SELECTEDVALUE(Sales_Start[Sales Start])
   var _val_start = SELECTEDVALUE(Validity_List[Sales start])
   var _val_End = SELECTEDVALUE(Validity_List[Sales End])
   var _Quan = SELECTEDVALUE(Validity_List[Quantity])
   RETURN
   IF(_sale <= _val_start && _sale > _val_End , _Quan , BLANK())

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

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