Forum Discussion

kmartink's avatar
kmartink
Frequent Visitor
3 years ago
Solved

Measure including a text and a calculated column

Hi, I want to create a measure showing a text1 before and text2 after a calculated column referenced in this measure. How can I do this?

 

The calculated column is a result of a division of two other columns, which is rounded to the whole number:

Number.Round(([#"column1"]/[#"column2"]),0,RoundingMode.AwayFromZero)

 

Thank you for your reply in advance!

 

1 Reply

  • kmartink 

     

    Measure = "text1" & sumx( 'Table', column1 / column2) & "text2"