table connection

[nbmalla]

I have date table and sales table.

Date table I created using Dax fomula and have year, month,day,weeknum columns.

Sales tabel has only one year data and colums are a year, weeknum(whole number data type) and sales from different channel.

Year	Week	In Store	4PD	Online	DAAS	Catering
2023	1	16,684	11,422	3,038	816	300
2023	2	15,766	12,058	3,745	1,043	176
2023	3	17,798	13,357	3,001	603	313
2023	4	18,517	17,609	3,308	714	790
2023	5	18,709	15,507	3,779	1,217	360
2023	6	18,027	16,901	3,295	842	102
2023	7	16,705	14,181	2,891	836	1,396
2023	8	14,755	14,322	3,046	612	911
2023	9	17,281	14,525	3,466	401	883
2023	10	18,281	15,217	2,937	700	737
2023	11	17,437	15,606	2,802	496	0
2023	12	17,413	13,913	2,889	795	657
2023	13	20,203	12,915	3,215	813	488
2023	14	19,834	16,544	3,254	687	1,705
2023	15	18,909	15,669	3,617	719	1,004

rows goes on. How to connect to date table?
Can you please hepl me.

[Anonymous]

Thanks @jdbuchanan71 ,

That helped me a lot

[jdbuchanan71]

Take a look at this post about converting week to dates.

https://community.fabric.microsoft.com/t5/Desktop/convert-week-number-into-data/td-p/88227