Relationship for multiple columns (Most efficient Way)

[GeorgeVepkhvadz]

I have huge dataset (over 30GB) and now I need to create relationship betwee two tables, one gas over 40milion rows and is increasing rapidly each month, the other is daily and has almost bilion rows.  

The issue is, I need to create relationship based on date and customer key.  (One is monthly, other is daily, so first I have to make daily date as start of month and then concatenate two columns and create relationship).  However, it became huge number, and is quite expensive for dax.  ( I tried to convert date to value and substract years of it, to make date number shorter, now it is 3 digits but soon will be 4).  Like this:  01/01/2022  = 100 ,  01/02/2022 = 131  etc.. 

But even like this I believe it is not optimal, is there better solution for this? 

[amitchandak · Accepted solution]

@GeorgeVepkhvadz , Integer join works best for date you can integer in YYYYMMDD format

Year([Date])*10000 + Month([Date]) *100 + Day([Date])