topic How to link with date table with columns having "Month Usage", "Month Domain", "Month Users" in DAX Commands and Tips

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

Anonymous — Sun, 29 Nov 2020 06:03:03 GMT

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,

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

MattAllington — Sun, 29 Nov 2020 10:24:10 GMT

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.

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

wdx223_Daniel — Mon, 30 Nov 2020 01:57:23 GMT

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