Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
The fields Delivered Duration and Planned Duration are Short Time fields
@Greg_Deckler @AndrewPF @amitchandak
@spandy34 , A measure like
divide( countrows(filter(Table, datediff([planned], [Delivery], minute) >10)) , countrows(Table))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |