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.
Hello Everyone
I'm hoping to get some help on a DAX formula that is above my current skill level
The company I work for has a requirement that supplier delivers must be +/- 3 days form the "Promise Date" otherwise its considered "Received Late" ("Receipt date" is more then 3 days past "Promised Date") or " Received Early" ("Receipt Date" is more then 3 days before "Promised Date".)
or
If the "Receipt Date" is blank (not yet received) then its "Pending" or if the current date is greater then 3 days past "Promised Date" its "Late Not Yet Received"
I wanted to add a new Column called "Status" to show the evaluation result (Received Late, Received Early, Received On Time, Pending, Late Not Yet Received"). I figure I can use a slicer in my visual to filter for a specific "Supplier Name" or "Promise Date" range. below is a clip of my data table. Any help/guidance you could provide is greatly appreciated! ☺
Thanks
Rick
Solved! Go to Solution.
Hi:
You can try this calc column. I named table "Deliveries" so you can change bolded part to your tables name. You can also use switch statment but I went old school on this one.
Hi:
You can try this calc column. I named table "Deliveries" so you can change bolded part to your tables name. You can also use switch statment but I went old school on this one.
Thanks Whitewater100, worked great!!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |