Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sujit_Thakur
Solution Sage
Solution Sage

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

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
Sumanth_23
Memorable Member
Memorable Member

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!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



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)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.