Combining two tables with different row count

[syoon]

Hi all,

Here I have 2 queries, one showing the billing history and the other showing the cash-in history.

I would like to combine these two. My goal is to get both Cash-in and Billing columns on one table so that later I can easily calculate Outstanding Cash-in (equivalent to Billing - Cash-In). 

One problem is that two tables have different number of rows. Therefore, two tables doesn't necessary match. However, both contain same names. 

I initially tried grouping by name, but that condenses "date", which is not what I want because I am trying to use Date slicer and condensing dates would hinder that.

To summarize:

1. I want to have Cash-in and Billing columns on the same table (unless there's a way to calculate without having them on one place)

2. Date must not be condensed.

Any suggestion / comments on how to solve this problem? Any suggestion would be greatly appreciated.

Thank you!

[v-piga-msft]

Hi @syoon,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry

[Anonymous]

Hi Cherry,

I believe you @ the wrong person, I am not the one who posted the question.

Thanks

[v-piga-msft]

Hi @syoon,

Have you tried with the way @Anonymous suggested? 

For another option, you could create a reationship between the two tables and create a bridge table to get Billing and Cash-In,

then you could use dax to calculate the value.

Hope this also can help you!

Best Regards,

Cherry

[Anonymous]

Hi,

I believe you could just using Merge Query in Query Editor, as you can select the date and using left outer or anything depends how you want the table, or you could just play around, see what result you want. 

Hope it works.