Forum Discussion
Merging calculated tables based on 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 ...
Try to create a new table like below:
Table = NATURALLEFTOUTERJOIN ( 'Table A','Table B' )
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.