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", but it will calculate the sum of the gross value.
However, it is giving me an error that I can't solve.


These are my formulas:

Sin liquidar = SUM(Consulta2[BrutoMenosBonificacion])
Bruto NOBLANK = IF(ISBLANK([Sin liquidar]), "Nada pdte.", [Sin liquidar])
 
And this is the error I am getting: "Expressions that produce Variant data types cannot be used to define calculated columns."
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") )

     

     

2 Replies

  • 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") )

     

     

    • afrutos's avatar
      afrutos
      Resolver I
      4 years ago

      Thank you is totally working for me now, could you please explain it to me why you do that?