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

  • yaya1974's avatar
    yaya1974
    Icon for Helper III rankHelper 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!