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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Should I check if value is blank or blank()

If I  want to avoid returning blanks... and I have a measure, like:

 

Revenue YTD:=
VAR RE= [Revenue YTD (Formatted)]
RETURN
IF(RE=BLANK(),      --or RE=BLANK?!
0,
RE)

 

In the IF, should I check if RE=BLANK() or RE=BLANK ?

1 REPLY 1
Pragati11
Super User
Super User

HI @Anonymous ,

 

You need to check - IF RE=BLANK() 

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.