Creating new table by combining / Joining 2 non related tables together

[fetster]

I'm using Power BI to analyse data from my EPOS till systems.

I'm looking to combine tables from our admission till system and our food till system into one table which holds data from them both.

There is no relationship between the two tables. Table 1 has columns:
Transaction Date, Transaction Time, Product Code, Value, Quantity, TransNo

Table 2 has columns:
Date Paid, Time Paid, itemID, Quantity, Till, Price,Discount

As I say there is no relationship between the data, a lot of the transactions in both tables will have occurred at the same date / time but they are not related.

Any idea how this can be achieved please?

[Mi2n]

If there is no relation between the two tables, why do you need to have them joined into a single table?

It does not seem to be a good data modelling practice. If you provide a valid reason, then you can get help.

[fetster]

Hi Mi2n, thanks for taking time to reply. 

I'm wanting to run reports based on data from both tables - 

I have a product table that categoises each product by sub type and by mayor group (coffee, food & drink category / child admission, admissions category).

I want to run reports for the products sold over time / revenue by product etc  categorised into groups and individually so will need to query both tables. 

I just assumed that i would need to combine the two, create columns with common calculations (such as sales revenue / quantity sold).

Sounds like you are saying i don;t need to join them which is better but how would I still be able to run such reports / calculations if data is over 2 tables? 

Hope my response makes sense - as you can probably tell i'm a novice to Power BI / Data Modelling. 

Thanks again 

[ElliotP]

Hopefully you can just use the columns and data in your second table to model for example revenue.

If you want, you could share your pbix or a screenshot of your data.

You might be able to link the tables if you want through a unique transaction ID or a date time stamp or something like that; but you also may not even need to.