Join 2 tables

[Anonymous]

Good day,

I trust this message finds you well.

I have got 2 Sales dataset - 1 is a monthly view (compares the current month to previous month) and a yearly view which has data from March 2020 to date. Both the Datasets have similar columns except that the Yearly dataset has few columns. The common columns between the 2 datasets is "Branch Code", Channel, "Transaction month" and the 2 measures (Sales Value and Quantity).... May someone please assist and guide me with how I can join the 2 datasets.

Kind Regards,

Thanks,

[amitchandak]

@Anonymous , I usually create a date from month and year and then either distribute that data at month or day level. 

Once you have date you can use a date table. Join both with them

Or I take advantage of time intelligence function if you do not want to distribute the data.

Create day/month level data

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290

Without allocation using TI measures

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400

Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798