Forum Discussion
Solved
Get value from another table based on 2 conditions
Hello I am new to PowerBI and don't even know where to begin with this formula. I have 2 tables, one is called "cr791_hourlytracking", the other is a list of invoice numbers with account and week st...
- I tried this and it didn't work. Returned blanks. Not sure whyLOOKUPVALUE(Table1[Invoice Number],Table1[Week of],cr791_hourlytracking[Week Start Date],Table1[cr791_Account],cr791_hourlytracking[Account])
I tried this and it didn't work. Returned blanks. Not sure why
LOOKUPVALUE(Table1[Invoice Number],Table1[Week of],cr791_hourlytracking[Week Start Date],Table1[cr791_Account],cr791_hourlytracking[Account])
That seems like it should work unless there are multiple Invoice Number values for a given week and account.
Can you verify that both week columns are date type and the dates do align like you expect?
Yeah that fixed it. I guess when I made the list of invoice numbers and dates I messed up. I cleaned it up and the formula worked.
