Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

LookUp

Hi all, I have ContID in Dim table and I have ContID in Fact table, I want to get only those ContID's in dim table into fact table Instead of Inner Join on ContID's from two tables I weanna do...
Need Help
Cbutler's avatar
Cbutler
Icon for Helper III rankHelper III
3 years ago

Could use a Lookupvalue calculated column? This will bring the value from one table in to the other, no relationship required. 
LOOKUPVALUE – DAX Guide

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Might be, I have doubt on this

    I just want to filter Id's in 2nd table for the id's which are present in 1st table

    • AmiraBedh's avatar
      AmiraBedh
      Icon for Super User rankSuper User
      3 years ago

      Can you please provide more details?
      I already provided an answer.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi,
        Actually in SQL lvel I was doing Inner Join based on ID  IN fact on dim table, it's giving lot of refreshing issue
        data size is like 38M, so it's taking 3.5hrs to refresh
        So I need alternate sol for that