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

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.

3 Replies

  • 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.