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]
speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Hi Nycso94

Try this  and click thumbs up and Accept As Solution please ! 

 

Last result =
VAR usermaxdate =
CALCULATE(
MAX(Surveys[Date]),
ALLEXCEPT(Surveys,Surveys[User])
)

RETURN
CALCULATE(
MAX(Surveys[Result]),
Surveys[Date] = usermaxdate
)