Forum Discussion

NadaBen's avatar
NadaBen
Helper I
9 years ago

Information flow between 2 tables

Hello, i have 2 tables : my lookuptable is : 'common period' and data table is 'stock', they are linked by :
Commonperiod[day] and stock[last day of week], i don't know why i don't have any information displayed when trying to get a chart with common period[day] as an axis?? Is it because last day of week is a calculated column? , i have checked that i have the format date for both of them, and used " userelashionship" function between the tables?? What could go wrong between these 2 tables?

Many thanks :)



Many thanks.
Need Help

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi NadaBen

     

    What if you try and create a relationship between the two tables linked on the Commonperiod[day] and stock[last day of week] columns instead of using the LOOKUP?

    • NadaBen's avatar
      NadaBen
      Helper I
      9 years ago

      Hi GilbertQ,

       I have already a relationship between  these two  tables, i used lookupvalue only to  calculate the column: Last day of week of "stock " table  .

       

      Do you see any other solution ??

      • GilbertQ's avatar
        GilbertQ
        Super User
        9 years ago

        Hi NadaBen

         

        What you could do is to create the calculated column inside your data model. Using DAX it is often easier to create the column.