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
sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
2 years ago

If there are no relationships between the tables, you should be using LOOKUPVALUE or TREATAS.

  • yaya1974's avatar
    yaya1974
    Icon for Helper III rankHelper III
    2 years ago

    ok.  I did sorta get it to work.  using lookupvalue.  However, the issue is from Table 1. The adj column is not filling in all the way, so I first need to get issue in table 1 fixed.  here is my dax code for adj column in table 1.  can anyone help fix this?

     

     

    Thank you!

     

    • sjoerdvn's avatar
      sjoerdvn
      Icon for Solution Sage rankSolution Sage
      2 years ago

      mmm, didn't you say that your date columns where actually text type? If that is the case than things like MIN, MAX and EARLIER are not going to work if the date format is mmm-yy. 
      So you would need to create a proper date column first, and although you could try that in DAX, I would advice to do that in Power Query or even in the source if that's possible.

      • yaya1974's avatar
        yaya1974
        Icon for Helper III rankHelper III
        2 years ago

        Correct they were text, but I did already switch to date, to get the lookupvalue to work.  

        Biggest issues is getting all rows to fill in.   Thanks!