Data from one table to another table with multiple conditions and value type

[marabeda]

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

[Anonymous · Accepted 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.

[vapid128]

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.

[marabeda]

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

[marabeda]

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.

[marabeda]

HI, vapid128 does not work correctly, test2 does not take the correct value. I have to find another solution. Any help?

[marabeda]

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]