Forum Discussion

po's avatar
po
Post Prodigy
7 years ago
Solved

Force inner join possible

Hi,   Have the following      sales table with date on it   calendra table with date on it.   Calnedra has an entry for every date whereas sales has an entry only if sales on those dates.  ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi po

     

    You may create relationship between the two tables as below. Then drag the calendar date column and sales data in one visual.

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi po

 

You may create relationship between the two tables as below. Then drag the calendar date column and sales data in one visual.

Regards,

Cherie

po's avatar
po
Post Prodigy
7 years ago

Thanks for replies.