Forum Discussion

VHosamane's avatar
VHosamane
Frequent Visitor
7 years ago

Generating reports from unrelated tables

I have a RAW Table which contain employee timesheet entries for a project and client for each month. Later I have grouped this table so I can get total timesheet hours by client, project and month. ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Why can't you create a combined key for both tables where you create a column that concatenates, for example client ID, project ID and month?

 

Outside of that, you should be able to accomplish this with measures by grabbing your client ID, project ID, etc from your table and then doing a FILTER on your other table and then a SUMX across that, for example.

  • VHosamane's avatar
    VHosamane
    Frequent Visitor
    7 years ago

    Greg,

     

    Thanks for your response.

     

    I am new to Power BI & I am not clear how to move forward with what you said in your second paragraph. I was able to create a new column with ClientID, ProjectID and Month in both RAW and Ledger table. But needs help creating the measure which you mentioned in your 2nd paragraph.

     

    It is summing all the CashIn and summing all the Invoiced irrespective of month and repeating the respective total for all the months. So it's not filtering by ClientID, ProjectID and Month.

     

    So I need the syntax to create a measure which will give me CashIn and Invoiced based on ClientID, ProjectID and Month. 

     

    Thanks.