cancel
Showing results for
Did you mean:
Highlighted
Impactful Individual

## Table

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%+

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Impactful Individual

## Re: Table

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)

2 REPLIES 2
Highlighted
Memorable Member

## Re: Table

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!
Highlighted
Impactful Individual

## Re: Table

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)

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021