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.
Hey Guys,
I dont seem to be getting the right behaviour with the folowing dax statement in a calculated column:
WO Completion Date =
if('Work Orders'[Closed?]="Closed",'Work Orders'[Malfunction End Date],
if('Work Orders'[Malfunction End Date]=blank(),'Work Orders'[Max Labour Date],
if('Work Orders'[Max Labour Date]=blank(),'Work Orders'[Pseudo Complete date],
blank())))
WO Completion Date | Closed? | Malfunction End date | Max Labour Date | Pseudo Complete date |
1/1/2018 | Closed | 1/1/2018 | 6/7/2017 0:00 | |
1/2/2018 | Closed | 1/2/2018 | 6/7/2017 0:00 | |
1/3/2018 | Closed | 1/3/2018 0:00 | ||
Open | 6/7/2017 0:00 |
I want to create the above result set in calculate column "WO Completion Date" where:
if the record has the status of "closed" then populate dates from the following columns in this order of preference
Malfunction End date | Max Labour Date | Pseudo Complete date |
if record is "open" leave column blank.
Help me out here guys, under pressure with this 😞
Regards
Cowboy Tony
Solved! Go to Solution.
Hi @CowboyTony,
Below Dax formula should solve you problem.
WO Completion Date = if('Work Orders'[Closed?]="Open",BLANK(), if('Work Orders'[Closed?]="Closed", if(ISBLANK('Work Orders'[Malfunction End Date])=FALSE(),'Work Orders'[Malfunction End Date], if(ISBLANK('Work Orders'[Max Labour Date])=FALSE(),'Work Orders'[Max Labour Date], if(ISBLANK('Work Orders'[Pseudo Complete date])=FALSE(),'Work Orders'[Pseudo Complete date])))))
Thanks,
Rahul
Hi @CowboyTony,
Below Dax formula should solve you problem.
WO Completion Date = if('Work Orders'[Closed?]="Open",BLANK(), if('Work Orders'[Closed?]="Closed", if(ISBLANK('Work Orders'[Malfunction End Date])=FALSE(),'Work Orders'[Malfunction End Date], if(ISBLANK('Work Orders'[Max Labour Date])=FALSE(),'Work Orders'[Max Labour Date], if(ISBLANK('Work Orders'[Pseudo Complete date])=FALSE(),'Work Orders'[Pseudo Complete date])))))
Thanks,
Rahul
Works perectly, really appreciate it 🙂
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |