cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## Condition to be Calculation with Multiples Tables.

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 ?

thanks you so much.

1 ACCEPTED SOLUTION
Community Champion

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"
)```

Thank you for the kudos 🙂

3 REPLIES 3
Community Champion

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"
)```

Thank you for the kudos 🙂

Post Prodigy

@Stachu you are awesome. thanks you

Community Champion

thanks 🙂

Thank you for the kudos 🙂

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors