Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table called Procurement_Main_Data and want to create a column that will put a yes if the Delivered Duration is 10% greater than the Planned Duration otherwise say No
The fields Delivered Duration and Planned Duration are Short Time fields
Please can someone help
Many thanks
Solved! Go to Solution.
because you write the measure incorrectly.
this is how you should write it:
10% Over =
if([Variance %]>0.1,"Yes","No
10% Over =
VAR _limit = MINUTE([Planned Duration])*(1+0.1)
VAR _Results = if(MINUTE([Delivered Duration])>_limit,"YES","NO")
RETURN
_Results
10% Under =
VAR _limit = MINUTE([Planned Duration])*(1-0.1)
VAR _Results = if(MINUTE([Delivered Duration])<_limit,"YES","NO")
RETURN
_Results
------------
OR
10% Over =
VAR _limit = MINUTE([Planned Duration])*1.1
VAR _Results = if(MINUTE([Delivered Duration])>_limit,"YES","NO")
RETURN
_Results
10% Under =
VAR _limit = MINUTE([Planned Duration])*0.9
VAR _Results = if(MINUTE([Delivered Duration])<_limit,"YES","NO")
RETURN
_Results
Ive added another column called Variance Column. The majority of rows are fine for the 10% Under and10% Over Columns but was wondering why the records filtered in the 10% Over Column is saying 'No' when the Variance % is 1000%. The Variance % field is Percentage format and Data Type Decimal Number
Any ideas? Thank you for your ongoing support
because you write the measure incorrectly.
this is how you should write it:
10% Over =
if([Variance %]>0.1,"Yes","No
Thank you thats done it. Really appreciate your help as always:)
10% Over =
VAR _limit =
(HOUR([Planned Duration]) *3600 + MINUTE([Planned Duration])* 60 + SECOND([PlannedDuration]))*1.1
VAR _Results = if(
HOUR('Table'[Delivered Duration]) *3600 + MINUTE('Table'[Delivered Duration])* 60 + SECOND('Table'[Delivered Duration])
>_limit,"YES","NO")
RETURN
10% Under =
VAR _limit =
(HOUR([Planned Duration]) *3600 + MINUTE([Planned Duration])* 60 + SECOND([Planned Duration]))*0.9
VAR _Results = if(HOUR('Table'[Delivered Duration]) *3600 + MINUTE('Table'[Delivered Duration])* 60 + SECOND('Table'[Delivered Duration])<_limit,"YES","NO")
RETURN
_Results
Hi so I need it to say yes if it great than 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
according to your table, there will be "NO" everywhere, I correctly understood your goal?
There is a lot of data.
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%'
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
70 | |
68 | |
43 | |
34 | |
26 |
User | Count |
---|---|
86 | |
49 | |
45 | |
38 | |
37 |