Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

IF ISBLANK Custom Column

‎10-15-2019 07:10 AM

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

Labels:
Message 1 of 3
3,336 Views
0
1 ACCEPTED SOLUTION
MCornish
Responsive Resident
Responsive Resident

‎10-15-2019 07:14 AM

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

Message 2 of 3
3,334 Views
0
2 REPLIES 2
MCornish
Responsive Resident
Responsive Resident

‎10-15-2019 07:14 AM

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

 

=if test then value_if_true else value_if_false

Message 2 of 3
3,335 Views
0
Anonymous
Not applicable
In response to MCornish

‎10-15-2019 10:26 AM

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

Message 3 of 3
3,295 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

View All