cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Edinson Frequent Visitor
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 Super Contributor
Super Contributor

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

v-haibl-msft Super Contributor
Super Contributor

Re: IF function error

@Edinson

 

Do you have any update about it?

 

Best Regards,
Herbert

Edinson Frequent Visitor
Frequent Visitor

Re: IF function error

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

 

problema.JPG

Highlighted
Super User
Super User

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!