cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Impactful Individual
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
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)

View solution in original post

2 REPLIES 2
Highlighted
Memorable Member
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+")
 
Column Check.png
 
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Highlighted
Impactful Individual
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)

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors