Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with advance IF function

Hi Friends,   I was trying to insert "Last Result" using some Ifs Dax Function, but the result is always "Not Done" or Errors. I just want to have in "Last Result" the last data in previous column...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use below in a custom column in PQ

    = [l=List.FirstN(List.RemoveItems(List.Reverse(List.RemoveFirstN(Record.ToList(_),1)),{"Not Done"}),1), r=if List.IsEmpty(l) then "Not Done" else Text.Combine(l)][r]
KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi Anonymous,

 

Add a custom column, add code below:

Replacer.ReplaceValue(List.Last(List.Select(List.Skip(Record.ToList(_),1), each _ <> "Not Done")),null,"Not Done")

 

 

Regards

KT