Selected Dates Slicer DAX

[DivakarKrishnan]

Dear ,

I have below requirement,

1. if value is 1 then result is 1
2. if current row and previous row is 1 then result is 2.
3. if current value is 0 then result is 0.

Date	Value	Result
9/11/2020	1	1
9/12/2020	0	0
9/13/2020	0	0
9/14/2020	1	1
9/15/2020	1	2
9/16/2020	0	0

I have written below DAX and it's giving current value when i am choosing all dates. However, when i am slicing only two dates (Example: 09/13, 09/15), still result is taking only previous day value.

DAX

Prev Day Values = SWITCH(

                    TRUE(),

                    SELECTEDVALUE(Table1[CNT])=1 && CALCULATE(SELECTEDVALUE(Table1[CNT]), PREVIOUSDAY('Date' [Date]))=1,SELECTEDVALUE(Table1[CNT]) + CALCULATE(SELECTEDVALUE(Table1[CNT]),PREVIOUSDAY ('Date'[Date])),

                    SELECTEDVALUE(Table1[CNT])=1, "1",

                    "0"  )

Please let me know how to make this DAX dynamic irrespective of date slicer.

Example If I choose 09/13 and 09/15, then DAX should take read 09/13 instead of 09/14 for 09/15 row.

[lbendlin]

You cannot use PREVIOUSDAY(), you need to use MAX() or LASTNONBLANK  with the condition that they be smaller than the current value.  It's the standard "previous row" pattern.

Do you want help with the DAX for that?

[DivakarKrishnan]

Yes please, i would appreciate it.

How to change my current DAX to handle my requirement with MAX()?