Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Manual data entry

I'm somewhat of a novice so I apologize ahead of time! 🙂  We are exporting data from our ERP system as it relates to revenue numbers.  I'm then able to import this data into Power BI Desktop and cre...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created some sample data to reproduce your scenario.

    Sheet1(data in Excel):

    Sheet2(static data entered by 'Enter Data'):

     

    Then you may go to 'Query Editor', create an index column for 'Sheet1' and 'Sheet2'.

     

    Then you need to go to 'Home' ribbon, click 'Merge Queries', set as below.

     

     

    Finally you need to expenad the column to get the result. You may remove the index column if you don't want to load it into the model.

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

But if I have that data in a separate spreadsheet then the data isn't linked to the other data anymore is it?  Along with projections I'm also looking to have historical data shown.  Which again is static but it has to all be linked with the current data for it to make sense.  Sorry if I'm using the wrong terminology.

DataInsights's avatar
DataInsights
Super User
6 years ago

The data would be linked in Power BI using common dimensions (e.g., Account, Dept, Year, Month). Each flat file would have the common dimensions, along with amounts. Each flat file would be a separate query in Power BI. Can you attach a snapshot of each of the three flat files so I can better understand your data (anonymize your data)?