Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am brand new to Power BI and having a few issues to look up values between 2 columns in another table.
So, I have two tables (placed below) and I am trying to take value from TABLE1 in the column "In Serial" and according the column "Data" (date) go to TABLE2 match the date and then look up the value between two columns "Value in" and "Value out" when it found, the desired result is to add a new column in TABLE1 with the information as "text" from Column "ProgramN" in TABLE2.
The result would be something like this:
Thank you very much in advance for any help!! Please let me know if you would like any additional information 🙂
Solved! Go to Solution.
try this code as calculated column in Table1, you may need to adjust table and column names
ProgramN = VAR __Date = 'Table1'[Data] VAR __InSerial = 'Table1'[IN SERIAL] VAR __RelevantRowsTable2 = FILTER ( 'Table2', 'Table2'[Date] = __Date && 'Table2'[Value in] <= __InSerial && 'Table2'[Value out] >= __InSerial ) RETURN CALCULATE ( FIRSTNONBLANK ( 'Table2'[ProgramN], TRUE ), __RelevantRowsTable2 )
Proud to be a Datanaut!
Thank you Stachu. I tried this solution. I spent 2 weeks for this.
try this code as calculated column in Table1, you may need to adjust table and column names
ProgramN = VAR __Date = 'Table1'[Data] VAR __InSerial = 'Table1'[IN SERIAL] VAR __RelevantRowsTable2 = FILTER ( 'Table2', 'Table2'[Date] = __Date && 'Table2'[Value in] <= __InSerial && 'Table2'[Value out] >= __InSerial ) RETURN CALCULATE ( FIRSTNONBLANK ( 'Table2'[ProgramN], TRUE ), __RelevantRowsTable2 )
Proud to be a Datanaut!
Stachu thank you very much, I spent much time trying to resolve this, now it worked, so happy, thx!! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |