Forum Discussion
Helper IHow to Sync the dates from 2 different sources
Yep, as along as your date types are date or date/time, it should work fine. Note *this* is the mode you are looking for...
On the modeling tab of PBI desktop, you can click the "New Table" button, and use Calendar = CALENDARAUTO()... which should magically work to give you a new calendar table (which has the required... exactly 1 row for every day).
(Bunches of other ways to create calendar tables, but .... you need one). Then just create your relationships and ... generally use your calendar table for most anything involving dates.
Helper IAnonymous,
I tried to create a new table using CALENDARAUTO() function but unfortunately it is not allowing to make relation between these 2 data:
https://drive.google.com/file/d/0Bw-NoGKVJq_nSEl0bFpQdnNRc0k/view?usp=sharing
https://drive.google.com/file/d/0Bw-NoGKVJq_nMDRIQzMtVi03Nkk/view?usp=sharing
Can you try from your side