Forum Discussion

yaya1974's avatar
yaya1974
Helper III
2 years ago

Need formula help

Hello,  I have 2 tables with absolutely nothing to create a relationship.  But I need data from the first table into the second table, filtered on data from the second table.  I have this formula but...
CUSTOMCOLUMN
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, yaya1974 

I am glad to help you.

 

Since there are no relationships between the tables, the formula in ALLEXCEPT in the DAX formula you provided does not achieve the result you are expecting. 

 

Could you please provide some examples of text format data in the tables (excluding sensitive data), along with your expected results, calculation logic and special examples. Simplified pbix files would be great. 

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

yaya1974's avatar
yaya1974
Helper III
2 years ago

My formula works, I am getting the correct output, BUT I need it to fill in the rest of the rows.  I have color coded the rows that need filled in with the same number.  My code just needs to be corrected somehow to fill in, I just can't figure that out.

Thank you!