Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 Table B in Table A, and blank when there is no data for the specified date in Table A (Table A's custom calendar has more cardinality than Table B's dates column)
Any help would be greatly appreciated,
thanks
Solved! Go to Solution.
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |