Forum Discussion

lavina03's avatar
lavina03
Icon for Helper I rankHelper I
10 years ago
Solved

How to Sync the dates from 2 different sources

HI,   I need help on or possible way for my below scenario   I have data coming from 2 different sources   Source A shows - Resource booked on daily bases   Source B shows - Resource log ho...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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... 

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

lavina03

 

To find out the missing dates, please follow the below steps.

  1. Create a calendar table.
    DimDate = CALENDAR(MIN(sample_data[day]),MAX(sample_data[day]))
  2. Create a calculated table.
    Missing Dates = FILTER(DimDate,ISBLANK(LOOKUPVALUE(sample_data[day],sample_data[day],DimDate[Date])))

Anonymous's avatar
Anonymous
Not applicable
10 years ago

you should build a separate calendar table that has all dates, then create relationships to your other date related columns.