Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

calculation

Hi,
I calculated a column:
Orders with standard factor = IF('Fact_UM'[Factor] >'Fact_UM'[Standrad factor], 'Fact_UM '[Menge])
I would like to add that if standard factor is blank than column will show "no data"  in that row. 

Thank you for help!
Aleks

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Due to the limitations of calculated columns, using calculated columns will result in an error of "Expressions that yield variant data-type cannot be used to define calculated columns", it is recommended that you change the measure values and display them as a visual in the table.

     

    (1)We can create a measure. 

    Measure = IF(SUM('Table'[Column])==BLANK(),"no data",SUM('Table'[Column]))

    (2)Then the result is as follows.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

5 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Anonymous 

    try lik

    Column=
    IF(
    Fact_UM'[Standrad factor]=BLANK,
    "no data",
    IF('Fact_UM'[Factor] >'Fact_UM'[Standrad factor], 'Fact_UM '[Menge])
    )
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Yes, I was trying this but doesn't work. I get this error "Expressions that yield variant data-type cannot be used to define calculated columns."

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        Hi Anonymous could you paste some sample data and let us have a look?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Due to the limitations of calculated columns, using calculated columns will result in an error of "Expressions that yield variant data-type cannot be used to define calculated columns", it is recommended that you change the measure values and display them as a visual in the table.

     

    (1)We can create a measure. 

    Measure = IF(SUM('Table'[Column])==BLANK(),"no data",SUM('Table'[Column]))

    (2)Then the result is as follows.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.