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]
speedramps
Super User
Super UserPlease can you provide an example table of the input data and desired output report.
You can do this using copy and paste.
Do not send a screen prints.
Tables are much better because can import date and create an example solution.
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!