Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

operations with directQuery tab

Hello, I want to ask you for help. I have tab1 on local and tab2 with directQuery connection. In tab1 is column "project_number" with a lot of duplicities. In tab2 is also "project_number" but ther...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Below is my table1:

    Below is my table2:

    The following DAX might work for you(try to create a measure and a index column):

    Measure = 
  var tab_1 = SELECTEDVALUE(Tab1[Project_number])
  return
    IF(tab_1<> "-" && tab_1<>" " , LOOKUPVALUE('Table'[parameter],'Table'[project_number],tab_1)," ")

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

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

Below is my table1:

Below is my table2:

The following DAX might work for you(try to create a measure and a index column):

Measure = 
  var tab_1 = SELECTEDVALUE(Tab1[Project_number])
  return
    IF(tab_1<> "-" && tab_1<>" " , LOOKUPVALUE('Table'[parameter],'Table'[project_number],tab_1)," ")

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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