Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
scabral
Helper IV
Helper IV

replace blank with lookupvalue

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

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.