Reply
Highlighted
Frequent Visitor
Posts: 8
Registered: ‎06-27-2017

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!

Super Contributor
Posts: 4,720
Registered: ‎07-08-2016

Re: IF function error

@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

Super Contributor
Posts: 4,720
Registered: ‎07-08-2016

Re: IF function error

@Edinson

 

Do you have any update about it?

 

Best Regards,
Herbert

Frequent Visitor
Posts: 8
Registered: ‎06-27-2017

Re: IF function error

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

 

problema.JPG

Super User
Posts: 1,666
Registered: ‎05-10-2016

Re: IF function error

@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
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!