How to link with date table with columns having "Month Usage", "Month Domain", "Month Users"

[Anonymous]

Hi,

I have created a date table with multiple columns such as Day, Week, Month, Quarter, Year, etc.

However, I don't know how to link it with my data set which does not have a direct date match. The columns in the second table are as follow:

Customer Name,

Amount,

Dec 2020 Users,

Dec 2020 Messages,

Nov 2020 Users, 

Nov 2020 Messages,

Oct 2020 Users,

Oct 2020 Messages,

Please note that I deal with data sets that are for an entire month and not by individual date (1,2,3,4....31). I have around 1,000 customers and therefore the tables would span over 1,000 rows. 

Could someone please help me connect my dataset with the date table so I can slice and dice based on months?

Thanks,

[wdx223_Daniel]

@Anonymous you can transform your customer data column into date, according its field names. then you can create a relationship to date table.

[MattAllington]

A calendar table does not need to be at the date level. It can be at the Month level, as you have Indicated. Just make sure you have a unique ID for the lowest level of granularity (mm:-yyyy) and a matching column in your data table.