Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Looking for help with this. Here is the formual I wrote:
Priority Status = if(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>10,"Alert",""), if(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>15,"priority","")))
There is a column that contains either the status of In Transit or Received. I am only interested in if the shipment is still In tranist.
There is another column that says how long it is in transit for. If it is greater than 10 days, then I want the Status to be alert. If its greater than 15 days, i want it to say priority.
For this formula, it will create the status of Alert for everything over 10 and it will not ever assign antything a priority status.
Solved! Go to Solution.
Had some time to write the code:
Priority Status = if(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>15,"Priority",if([Days in Transit]>10,"Alert","")),"")
You may add SWITCH Function as well.
Column = IF ( TransfersBI[BOL Status] = "In Transit", SWITCH ( TRUE (), [Days in Transit] > 15, "priority", [Days in Transit] > 10, "Alert" ) )
You may add SWITCH Function as well.
Column = IF ( TransfersBI[BOL Status] = "In Transit", SWITCH ( TRUE (), [Days in Transit] > 15, "priority", [Days in Transit] > 10, "Alert" ) )
You'll want to evaluate priority before alert. Anything over 10 fulfills your IF condition, so the code never goes to check the >15. Check for >15, then check for > 10.
Had some time to write the code:
Priority Status = if(TransfersBI[BOL Status]="In Transit",IF([Days in Transit]>15,"Priority",if([Days in Transit]>10,"Alert","")),"")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |