Forum Discussion

gustalem's avatar
gustalem
Icon for Helper I rankHelper I
4 years ago

How to link Sales and Target tables?

Hi everyone,    I have 3 tables, dates, sales and customers, and also I have to add an Target table, how can be created how I want, so I can decide which way is better.   Sales table has 4 column...
Need Help
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

gustalem , You should link it with the common date and customer table.

 

In case values are monthly or yearly refer

PowerBI 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

 

Power BI 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