Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

selecting a specific data in a table

Hi,

 

This is my first topic, I'm realy new at using Power BI. Please be indulgent :smileyhappy:

I have a table (TABLE1) gathering different combination of 3 data (numbers and strings) for which I have a specific result as a string.

DATA1.DATA3.DATA3 = result

Example :

A.1.N = a

A.1.S = b

A.2.N = c

........

 

In an other table (TABLE2), there are 3 differents columns indicating different combination (A1N, etc), and I would like to add a column giving the result for each combination (a, b, c, ....)

 

Can I have some help please ?

Thanks a lot !

 

 

Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    If you are doing this as a calculated column in ZTM01 you could use the LOOKUPVALUE() function (see https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax )

     

    Which I think would be something like the following in your model:

     

    LOOKUPVALUE( RELACHE[Validation],
    RELACHE[Cas], ZTM01[Condition 1],
    RELACHE[DELAIS AVANT SM], ZTM01[Condition 2],
    RELACHE[CRENEAU], ZTM01[Condition 3]
    )

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Please share a pic of two tables to understand how the data is structured.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Here is the table RELACHE with combinations of columns (CAS, DELAIS AVANT SM, CRENEAU) and the related results (VALIDATION)

      list of combinations and related solutions

      Here is the table ZTM01 in which I have combination of data (CONIDTION 1, CONDITION 2 CONDITION 3) and for which I want the related result (VALIDATION)

       

      data to analyze

      Actually I have found a solution, but it is a workaround and I would like to know a better way to do it.

      For both tables, I have concatenated the different combinations in the column CODE and I have created a relation "1 to many" between those two tables to find the related result. 

       

      Do you have an idea how to it based directly on three different columns (CONDITION1, 2 and 3) and not by concatenating ?

       

      Thanks for your help.

      • d_gosbell's avatar
        d_gosbell
        Super User
        7 years ago

        If you are doing this as a calculated column in ZTM01 you could use the LOOKUPVALUE() function (see https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax )

         

        Which I think would be something like the following in your model:

         

        LOOKUPVALUE( RELACHE[Validation],
        RELACHE[Cas], ZTM01[Condition 1],
        RELACHE[DELAIS AVANT SM], ZTM01[Condition 2],
        RELACHE[CRENEAU], ZTM01[Condition 3]
        )