Selected Dates Slicer DAX

DivakarKrishnan — Wed, 16 Sep 2020 13:00:11 GMT

Dear ,

I have below requirement,

if value is 1 then result is 1
if current row and previous row is 1 then result is 2.
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.

Re: Selected Dates Slicer DAX

lbendlin — Wed, 16 Sep 2020 20:19:41 GMT

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?

Re: Selected Dates Slicer DAX

DivakarKrishnan — Thu, 17 Sep 2020 01:19:14 GMT

Yes please, i would appreciate it.

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

topic Selected Dates Slicer DAX in DAX Commands and Tips

Selected Dates Slicer DAX

Re: Selected Dates Slicer DAX

Re: Selected Dates Slicer DAX