Get related record info in same table

[jja]

Hi

I have this tructure in my table
new_transactions

What user do they inspect some work done in this case it is recorded in G column as "suvirinimo patikra" and insoect stage in column U is recorded as suvirinimas where this component was made as "suvirinimas"(column G) by Darbuotojo nuoroda(Column) - 030.

As inpector recorder this suvirinimo patikra as failed(column S) want in my powerbi report to return this Darbuotojo nuoroda 030 aside this failed suvirinimo patikra record.

Can you help me to write this DAX query either as a measure or as a new column?

[v-kongfanf-msft]

Hi @jja ,

Maybe you can try formula like below to create calculated column:

FailedSuvirinimoPatikraEmployee = 
VAR InspectionStage = 'new_transactions'[Inspect stage]
VAR DarboTipoNuoroda = 'new_transactions'[Darbo tipo nuoroda]
RETURN
    IF(
        InspectionStage = "suvirinimas" && DarboTipoNuoroda = "suvirinimo patikra" && 'new_transactions'[Inspect type] = "failed",
        'new_transactions'[Darbuotojo nuoroda],
        BLANK()
    )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jja]

@v-kongfanf-msft 
In this case i want to return not that Employee who made "suvirinimo patikra" but emploee who made suvirinimas and the inspecting emploee found it failed. So in this case regarding data i sent it should return 030. Maybe it is easier to add some calculated column and in the original record add that it failed. Like i have failed inspection and then i need to find the original record and put there failed also?

[v-kongfanf-msft · Accepted solution]

Hi @jja ,

Try below:

FailedSuvirinimoPatikraEmployee = 
VAR InspectionStage = 'new_transactions'[Inspect stage]
VAR DarboTipoNuoroda = 'new_transactions'[Darbo tipo nuoroda]
RETURN
    IF(
         DarboTipoNuoroda = "suvirinimas" && InspectionStage <> "suvirinimas" &&  'new_transactions'[Inspect type] <> "failed",
        'new_transactions'[Darbuotojo nuoroda],
        BLANK()
    )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.