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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
filipebarros
Frequent Visitor

Try this if Columm doesn t otherwise if columm doesn t exist do that

Hi, I need help with a formula that replace null values to 0 if colum A and B exists , but often the columm B does not exist when  I do a columm to lines transformation. how would it be do write the try and otherwise to a columm that doesn t exists? I need this check at the begginning of the code because I have a lot of other code lines that need to know if the columm exists.

2 REPLIES 2
Anonymous
Not applicable

can you upload a sample?

 

 

Initial tableInitial table

 

Sum in power querySum in power query

 

Initial table with DeliveryInitial table with Delivery

  
  If I update a table without Delivery it doenst show The collum Delivery , and then the calculation gives a error because the columm Delivery does not exists










     
   
 
 
   
     
   
   
     
   
 


 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors