Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Dear Community, I need to transfer a value from a table to another table with multiple conditions and value type.
A create a sample of my table:
I try to managed with the lookupvalue but the function does not support text values compare with integer values.
Can anyone help on this matter?
Thank you
marabeda
Solved! Go to Solution.
Hi @marabeda ,
My lookupvalue function works fine.
Please try the following steps:
In “Table General” table , add a column with a dax formula
Lookup_Maxtime =
LOOKUPVALUE (
'Table Max time'[Max time],
'Table Max time'[Client ], 'Table General'[Client],
'Table Max time'[Day of week], 'Table General'[Day of week]
)
If I misunderstand your demands, please feel free to let me know.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @marabeda ,
My lookupvalue function works fine.
Please try the following steps:
In “Table General” table , add a column with a dax formula
Lookup_Maxtime =
LOOKUPVALUE (
'Table Max time'[Max time],
'Table Max time'[Client ], 'Table General'[Client],
'Table Max time'[Day of week], 'Table General'[Day of week]
)
If I misunderstand your demands, please feel free to let me know.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lookupvalue shuold work.
check your type of 2 [Day of week]
Or you can make combin index
index = [Clint]&[Day of week] on 2 tables
link index.
Hi vapid128, thx . I correct the type value in text and I used lookupvalue but with this expression:
Lookupvalue( max time[max time], max time[client], general[client],max time[day], general[day])
I get an error because the column contains too much row with same value.
Any idea?
thx a lot
Hi vapid128, I probably find the solution like this:
test2=CALCULATE(FIRSTNONBLANK(max time[max time],1),FILTER(ALL(max time), max time[Client]=general[Client] || max time[day] = general[day]))
I have to check if the data that I retrieve are correct.
Let you know.
HI, vapid128 does not work correctly, test2 does not take the correct value. I have to find another solution. Any help?
Sorry a mistake:
If Table general[Client]=Table Max time[Client] and Table general[Day of week]=Table Max time[Day of week] then table general[Max time]=Table Max time [Max time]
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |