Forum Discussion
Help with equivalent PowerBI ISNA and VLOOKUP Function
Anonymous add the following measure, change column, and table name as per your model.
Measure = VAR __status = CALCULATE ( LASTNONBLANK ( Timesheet[Status], 1 ) ) RETURN IF ( __status == BLANK(), "Missing", __status )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Super UserAnonymous add the following measure, change column, and table name as per your model.
Measure =
VAR __status = CALCULATE ( LASTNONBLANK ( Timesheet[Status], 1 ) )
RETURN IF ( __status == BLANK(), "Missing", __status )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
WOW! Thank you so much! I kept messing around with LOOKUPVALUE, RELATED, etc. and just could not get it to work right. I truly appreciate your help!
Do you have a basic source where I can learn more about measures, DAX functions, etc.? I hadn't really seen VAR or even _status used before.
Thanks again and I will make sure to mark your reply as the solution!
- parry2k
Anonymous I usually do very custom training in a batch of 5 which is mainly designed around basics of DAX and then talk about actual business problems. Send me an email directly if you are interested, I give discounts with batch of 3/5/10 and I usually prefer max 5 people in a session. Thanks!
My email is in my signature.