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 IHi ankitpatira,
Let me explain you my query:
I already have data coming from 2 different sources:
1) First Data is coming from API wherein I have 3 tables [resources], [projects], [resource booked]
2) Second data is coming from db wherein I have 3 tables [resources], [projects], [resource log hours]
The data from this 2 sources doesn't have any relation between them other then [resource email id]
3) So I created master user table to get common users from both these sources
4) Then I passed ID to projects tables so that they have common ID
5) Now the problem I am facing is I want to show stats based on projects wise say like
Project 1 for the month of June [resources booked v/s resource logged hours]
Microsoft Employee
lavina03 wrote:
Hi ankitpatira,
Let me explain you my query:
I already have data coming from 2 different sources:
1) First Data is coming from API wherein I have 3 tables [resources], [projects], [resource booked]
2) Second data is coming from db wherein I have 3 tables [resources], [projects], [resource log hours]
The data from this 2 sources doesn't have any relation between them other then [resource email id]
3) So I created master user table to get common users from both these sources
4) Then I passed ID to projects tables so that they have common ID
5) Now the problem I am facing is I want to show stats based on projects wise say like
Project 1 for the month of June [resources booked v/s resource logged hours]
Your requriement is not clear. We have no idea on what the tables are like and what relationship among them. Please give some sample data and expected output for further advice.
- lavina03
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
- Eric_Zhang
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.
- Create a calendar table.