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
spandy34
Post Patron
Post Patron

IF Calculated Column based on %

 I have a table called Procurement_Main_Data and want to create two columns.

 

I want to create a column that will put a yes  if the Delivered Duration is 10% greater than the Planned Duration otherwise say No and call it 'over 10%' also

 

I create a column that will put a yes  if the Delivered Duration is 10% less than the Planned Duration otherwise say No and call it 'under 10%'

 

eg 10% Over Column 

Planned Duration = 20 min and the Delivered Duration = 24 minutes 

10% of 20 minutes planned is 22 so if the Delivered Duration is more than 22 I want it to say Yes, otherwise no

 

also in the 10% Under Column

Planned Duration =  20 minutes  Delivered Duration = 12 minutes 

10% under of 20 minutes planned is 18 so if the Delivered Duration is less than 18 I want it to say Yes, otherwise No

 

spandy34_0-1679605549331.png

 

 

The fields Delivered Duration and Planned Duration are Short Time fields

 

 

@Greg_Deckler @AndrewPF @amitchandak 

 

1 REPLY 1
amitchandak
Super User
Super User

@spandy34 , A measure like

 

divide( countrows(filter(Table, datediff([planned], [Delivery], minute) >10)) , countrows(Table))

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.