Forum Discussion

1984's avatar
1984
Icon for Helper I rankHelper I
2 years ago
Solved

Multiple lookup

Hi I am relatively new back to using DAX and come up against my first conundrum. I have two tables, table one being a fact table with a 'Date' column and 'Name' column, then a lookup table with 'Nam...
Need Help
Show and Tell
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    CalculatedColumn=IF(COUNTROWS(FILTER(LookupTable,LookupTable[Name]=Table[Name]&&LookupTable[Start Date]<=Table[Date]&&LookupTable[End Date]>=Table[Date])),"Match","No Match")

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

CalculatedColumn=IF(COUNTROWS(FILTER(LookupTable,LookupTable[Name]=Table[Name]&&LookupTable[Start Date]<=Table[Date]&&LookupTable[End Date]>=Table[Date])),"Match","No Match")

  • 1984's avatar
    1984
    Icon for Helper I rankHelper I
    2 years ago

    Thank you wdx223_Daniel !