Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Joining calculated tables based on column dates

So I have a calculated Table A that has a custom calendar column, and calculated Table B that has a column "dates" and some other column. How do I merge these two tables so that I get all data from ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , if A is a calendar you can join on date. If B is on the many side you can get missing data using "show item with no data" of +0.

     

    If not, Create a calendar table mark it has date table and join with both tables and analyze them together with date table 

    To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , if A is a calendar you can join on date. If B is on the many side you can get missing data using "show item with no data" of +0.

 

If not, Create a calendar table mark it has date table and join with both tables and analyze them together with date table 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.