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 hours on daily bases

 

I want to know how I can create a stats resource booked v/s resource logged hours by monthly

 

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

13 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    lavina03 what you want to do is create a blank table in power bi desktop then use merge queries option and merge two data sources queries in third table. this will give you third query with all columns from both including dates. then simply use resource booked and resource log hours on any visual and choose any date field on x-axis. provided you have time intelligence on in power bi desktop (by default it is) you will have data by weekly, monthly and quarterly. you can also use slicer to see only for monthly.

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

      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]

       

       

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago
        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]

         

         

        lavina03

         

        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.

         

  • JuanBolas's avatar
    JuanBolas
    Icon for Helper II rankHelper II
    4 years ago

    Eric_Zhang thank you!  I had my relationships wrong.

     

    BTW, do you have any idea of why the subtotals measure is not working correctly? In some instances it adds something that doesn't appear in the columns.

     

    Thanks in advance.