Forum Discussion

yaya1974's avatar
yaya1974
Icon for Helper III rankHelper 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
Icon for Helper III rankHelper III
2 years ago

Hello,  thank you for responding.  Here is a screen shot of what I am looking for.  Unfortately I get blocked when trying to share a document.   Hope this helps.   My date columns are not "dates" they are text too btw.

 

 

Thank you for any help!

Lori