Forum Discussion
LookupValue issue
Hello, Im quite new in PowerBI and actually would like to kindly ask you for support. I had an formula which works for few weeks, and now stopped working> NazovOrg = if(isblank(UctDenikHelios[Ci...
Anonymous , try like
if(isblank(UctDenikHelios[CisloOrg]),UctDenikHelios[Spolocnost],calculate(firstnonblank(Organizace_Helios[Nazev],"n.a."),filter(all(Organizace_Helios),value(Organizace_Helios[SpolocnostID])=max(UctDenikHelios[SpolocnostId])&& (Organizace_Helios[CisloOrg])=max(UctDenikHelios[CisloOrg]))))
Thank you, amitchandak, it works. Im going to study more what exactly caused the issue, but you hacked it.👍😊