Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error * If statement for date

Hi,  I would like to create If Statement in my 2 Date Columns.  It works well in excel, but in Power Bi, it gives me the error warning.  What should I change to make it work? Hope to hear from yo...
Need Help
Show and Tell
  • ntaylo06's avatar
    ntaylo06
    7 years ago

    I believe that PBI is seeing "" as a string, even though it is empty. Try using:

    IF(ISBLANK('Table'[Field]), "if true", "if false")

     

ntaylo06's avatar
ntaylo06
Resolver II
7 years ago

I believe that PBI is seeing "" as a string, even though it is empty. Try using:

IF(ISBLANK('Table'[Field]), "if true", "if false")

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I will try and let you know later!!

Thanks for quick reply :)