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
Edinson
Frequent Visitor

IF function error

Help me with this new column

Tip_RQ = IF(Consolidado_RQ[Tipo de Requerimiento] = BLANK(),"Proyecto de Negocio",Consolidado_RQ[Tipo de Requerimiento])

which is the erro here, because when there is no value for Consolidado_RQ[Tipo de Requerimiento], still show (blank).

 

Pleas help me!

4 REPLIES 4
v-haibl-msft
Employee
Employee

@Edinson

 

Do you have any update about it?

 

Best Regards,
Herbert

It doesn´t works. The report still show (Blank) as you can see.

 

problema.JPG

Vvelarde
Community Champion
Community Champion

@Edinson

 

Hi, Let me understand your problem.

 

You always have TipoRequerimiento  (Data) to every CodigoProyecto. Or they are in different tables?

 

I think that the blank appears because they are not matching rows with the CodigoProyecto.

 

What happen if you add a measure CuentaFilas=Countrows(Consolidado_RQ)+0 in a card. What is the result. I think 0.

 

Let me see what happen.

 

Regards

 

Victor

Lima - Peru

 

 

 

 




Lima - Peru
v-haibl-msft
Employee
Employee

@Edinson

 

It seems that the if function works properly on my side. Do you have any sample data can be used to repro your issue? Or you can share your PBIX file through online file service like OneDrive.

 

IF function error_1.jpg

 

Best Regards,
Herbert

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.