Forum Discussion
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...
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]
Hi speedramps ,
Thanks for your reply!
My raw data is like this table:
| Name | May Survey Result | June Survey Result | July Survey Result | August Survey Result |
| User1 | Not Done | Not Done | Good | Not Done |
| User2 | Not Done | Good | Bad | Not Done |
| User3 | Good | Bad | Good | Bad |
| User4 | Bad | Good | Not Done | Not Done |
| User5 | Not Done | Not Done | Not Done | Not Done |
I want to create in PBI another column that has result of the last column with "Good" or "Bad" and if there isn't any "Good" or "Bad" insert "Not Done" (as the table that I sent in the post).
Thanks!
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalUse 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]