Forum Discussion
Power Query - Get data from another table if condition is met
Hi all, I need your help to get data from table 2 if some conditions are met there, and this in power query. I have a ref that I can found in both table, and I need to retrieve the "to return val...
Is IT because you See an Error or is it not selectable? Do you have the right linkage? Or is it just a Table as visual? Then you have to get the Data in the Backend Tables. Otherwise try to geht an measure feom your Table with calcualte(values( which you can select in the If Statement
Tables are well connected, however IF statement cannot compare a value from a cell to a table, I guess.