cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
markjohnson85 Frequent Visitor
Frequent Visitor

IF ISBLANK Custom Column

Hello everyone,

 

I am having issues with using a custom column using a IF ISBLANK formula to combine the UPS website tracking URL with the actual UPS tracking #.  I would like the formula to not populate the column if the tracking # is blank in the related column.  Below is a sample of my custom column.  Thanks!

 

UPS Custom.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
MCornish Member
Member

Re: IF ISBLANK Custom Column

That is the syntax for DAX, you need power query there.

 

=if test then value_if_true else value_if_false

View solution in original post

2 REPLIES 2
MCornish Member
Member

Re: IF ISBLANK Custom Column

That is the syntax for DAX, you need power query there.

 

=if test then value_if_true else value_if_false

View solution in original post

markjohnson85 Frequent Visitor
Frequent Visitor

Re: IF ISBLANK Custom Column

Thank you for the reply.  To confirm, I cannot use a custom column for this formula?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors