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...
Helper I
I know the requirements what I have provided is incomplete. I have figured out the issue and the dates are missing in my data.
Can you please provide me some solution or formula on how to compare or get the missing dates for the following data.
https://drive.google.com/file/d/0Bw-NoGKVJq_nMDRIQzMtVi03Nkk/view?usp=sharing
Microsoft Employee
To find out the missing dates, please follow the below steps.
- Create a calendar table.
DimDate = CALENDAR(MIN(sample_data[day]),MAX(sample_data[day]))
- Create a calculated table.
Missing Dates = FILTER(DimDate,ISBLANK(LOOKUPVALUE(sample_data[day],sample_data[day],DimDate[Date])))
you should build a separate calendar table that has all dates, then create relationships to your other date related columns.
- lavina03
Thank You Eric_Zhang,
I need help on how to make relations based on dates for the following data set.
https://drive.google.com/file/d/0Bw-NoGKVJq_nSEl0bFpQdnNRc0k/view?usp=sharing
https://drive.google.com/file/d/0Bw-NoGKVJq_nMDRIQzMtVi03Nkk/view?usp=sharing
I have attached a video on what I need
https://www.dropbox.com/s/d3b1urb6kdxi89s/2016-06-30_1241.swf?dl=0
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.
- lavina03
Anonymous,
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=sharingCan you try from your side
- lavina03
- Vvelarde
Community Champion
hi @lavina
You make sure that your dates column are in date format. After this the calendar auto will work.
