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.
Hi all ,
i'm seeking your strongly support here .
I have W/O Number table , Complete WO ( Which is calculated from another Table ) , Close WO ( Which is calculated from another Table ) , my purpose is :
*If Table :W/O Number = Table :Complete W/O , Show " Complete " If not ,"In Progress" , If Table : Complete W/O = Table : Close W/O , Show " Close" If not , " Complete Not Close "
I want all of the condition : Complete , In Progress , Close , Not Close , in the same Column ,
then it would be easy for me to visualize.
how can i success over this ?
your support is much appreciated.
thanks you so much.
Solved! Go to Solution.
what is the condition for Not Close? It seems identical to Complete to me. If that's the case this formula should work
Complete / Close = IF ( ISBLANK ( Dummy[Close WO] ), IF ( Dummy[W/O Number] = Dummy[Complete WO], "Complete", "In Progress" ), "Close" )
what is the condition for Not Close? It seems identical to Complete to me. If that's the case this formula should work
Complete / Close = IF ( ISBLANK ( Dummy[Close WO] ), IF ( Dummy[W/O Number] = Dummy[Complete WO], "Complete", "In Progress" ), "Close" )
thanks 🙂
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 | |
100 | |
86 | |
64 |