Forum Discussion

jja's avatar
jja
Icon for Helper III rankHelper III
2 years ago
Solved

Get related record info in same table

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 recor...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
jja
Icon for Helper III rankHelper III
2 years ago

Anonymous 
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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.