Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
i have the following lookupvalue function in SSAS tabular where i am joining on 3 different fields:
=LOOKUPVALUE(StagePolicyCbiPremium[USD Total Amount Effective],StagePolicyCbiPremium[Durable Prospect Client Identifier],'Policy Values'[Durable Prospect Client Identifier],StagePolicyCbiPremium[Durable Policy Identifier],'Policy Values'[Durable Policy Identifier],StagePolicyCbiPremium[Durable Client Business Interest Identifier],'Policy Values'[Durable Client Business Interest Identifier])
sometimes the StagePolicyCbiPremium[USD Total Amount Effective] is blank, but i want to replace it with 0.00 instead. I tried to use ISBlank function, but keep getting error. I'm not sure if this is the correct way to do it?
is there a way to replace the value coming backup from the lookupvalue function to a 0 if it is blank?
thanks
Scott
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 1 | |
| 1 | |
| 1 |