Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
hope I will get some help.
what I am looking is based on below table data looking to populate "Status"
1. if issue date < Planned Date then Status = " On Time"
2. if issue date > Planned Date then Status = " Late"
3. If Issue date = # and Planned Date < Today then Status = "Late"
4. If Issue date = # and Planned Date > Today then Status = "Waiting"
I wrote below code but having difficulties get 3 & 4 conditional results.
Thanks - Vemu
Requested Date | Planned Date | Issue Date | Status |
22/02/2023 | 20/02/2023 | 20/02/2023 | On Time |
21/02/2023 | 18/02/2023 | 17/02/2023 | On Time |
22/02/2023 | 20/02/2023 | 21/02/2023 | Late |
22/02/2023 | 20/02/2023 | # | Late |
24/02/2023 | 26/02/2023 | # | Wainitng |
Hello! Based on the conditions you have provided, you can modify your DAX formula to the following:
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |