Need previous values if current values is 0, it should check until it find value.

[pras_hant10]

Issue:

DAX should check until previous value is 0 (In Value), once its value is not 0 it gives me the date  (Result Needed) as below.

[az38 · Accepted solution]

Hi @pras_hant10 

try a measure

Result =
var _curDate = MAX(Table[Date])
RETURN
CALCULATE(MAX(Table[Date]); FILTER(ALL(Table); Table[Date] <= _curDate && Table[InValue] <> 0))

[az38 · Accepted solution]

@pras_hant10 

almost the same

Result =
var _curDate = Table[Date]
RETURN
CALCULATE(MAX(Table[Date]); FILTER(ALL(Table); Table[Date] <= _curDate && Table[InValue] <> 0))

[Syndicate_Admin · Accepted solution]

Hi @pras_hant10

dealing with a measure

Result =
var _curDate = MAX(Table[Date])
RETURN
CALCULATE(MAX(Table[Date]); FILTER(ALL(Table); Table[Date] <= _curDate && Table[InValue] <> 0))

[amitchandak]

@pras_hant10 , Try like

if(Table[Invalue]=0,maxx(filter(Table, table[Date]<earlier(Table[Date])),Table[Date]),Table[Date])

[pras_hant10]

I tried the same, but bellow result I am getting.

Result should be 01/02/2020 from row 2nd till last, as there is 0 In value.

[amitchandak]

@pras_hant10 ,

Try

if(Table[Invalue]=0,maxx(filter(Table, table[Date]<earlier(Table[Date]) && Table[Invalue]=0),Table[Date]),Table[Date])

[az38 · Accepted solution]

Hi @pras_hant10 

try a measure

Result =
var _curDate = MAX(Table[Date])
RETURN
CALCULATE(MAX(Table[Date]); FILTER(ALL(Table); Table[Date] <= _curDate && Table[InValue] <> 0))

[pras_hant10]

Thanks for your help, by my apologies, I am looking the logic for Column field.

[az38 · Accepted solution]

@pras_hant10 

almost the same

Result =
var _curDate = Table[Date]
RETURN
CALCULATE(MAX(Table[Date]); FILTER(ALL(Table); Table[Date] <= _curDate && Table[InValue] <> 0))

[pras_hant10]

Thank you. it work