Table

[Sujit_Thakur]

I have a calculated column where I have values in percentage.

What I want is one more column

Which shows value of last column if it is less than 300% and if it is more than 300 percent then it must show 300%+

[Sumanth_23]

hi @Sujit_Thakur - You can create a calculated column as shown below - the final column will be in TEXT format

%age Check = IF ( [Hours] < 3, "" & [Hours] , "300+")

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[Sujit_Thakur · Accepted solution]

Dear friend,

I wanted to do with fields with different values and limit.

I used measure and it's done .

Thanks for prompt response.

I came to know one more trick .

We can also use emoji in DAX coding / column coding , power bi will paste it.(use """") arround them .

Isnt it cool .

I used🚩 this flag in following code

Measure = var a = Sumx('Table'[Overload%])

var b = Related('Variant'[serial_Weight])

Return if(a<b,b&"🚩",a)