Forum Discussion
Join 2 tables
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,
1 Reply
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
