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.

 

tables linked on dates but calendar pulling back all rows.

 

How can we ensure only calendar rows with sales data are retrieved or filter out all rows from calendar with no sales data.

 

No inner join box on relationships setup.

 

Thanks

 

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

4 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    7 years ago

    Can you give some more information on how you are using the calendar and sales tables in a visual or in DAX? I have data with sporadic dates and cannot reproduce what you are describing.

     

  • LivioLanzo's avatar
    LivioLanzo
    Solution Sage
    7 years ago

    Hi po

    There is no INNER JOIN option. When you drop a measure which doesn't return any data (blank) the dimenion rows will be automatically filtered out

  • 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.