Information flow between 2 tables

Question

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.

gilbertq · Answer

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

anonymous · Answer

My best guess will be something w/ the relationship between the two tables. &nbsp;I would make sure bi-direction is off, and make sure the one side is your common dates table, the many side is your stock info.&nbsp;If you have dates on rows, what are you using for your values?

gilbertq · Answer

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

nadaben · Answer

Hi GilbertQ,&nbsp;I have already a relationship between&nbsp; these two&nbsp; tables, i used lookupvalue&nbsp;only to &nbsp;calculate the column: Last day of week of "stock " table &nbsp;.&nbsp;Do you see any other solution ??

nadaben · Answer

I have checked all this, but i don't understand what do you mean with&nbsp;which values i'm using?

Forum Discussion

Information flow between 2 tables

6 Replies

Related content

Rest API Informations

Missing information

Information button

Need information about capacity usage

Matrix table