Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

variant data-type error

Hi everyone, I need some help here. I have created a card where I need to get the gross value. I am trying to create a formula so that, if the gross value is blank, it will put "Nothing pending", ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    afrutos , Power bi can have two data types for a measure , here text and number

     

    what you can do is

    Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", [Sin liquidar]& "" )

     

    or

     

    Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", format([Sin liquidar], "###,###.00") )

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

afrutos , Power bi can have two data types for a measure , here text and number

 

what you can do is

Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", [Sin liquidar]& "" )

 

or

 

Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", format([Sin liquidar], "###,###.00") )