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!
- Vijay_A_Verma
Most Valuable Professional
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]