Forum Discussion
Dynamic Individual Target
Hi schoden ,
you can create such a calculated table.
Please refer to my .pbix file.
The target sales amount always changes dynamically with the latest actual sales.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
schoden , Not very clear. But I have two blogs on how to convert yearly target to daily and with some changes that can be used for months
powerbi 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
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
I have sales table that comes from SQL. Sales table has info on employee name, employee id, sales date and sales amount.
Now I want to compare individual sales with a target value which I created using dax on Monthly basis( it is static )
To this point, it works perfectly fine.
However I want to make it more dynamic, meaning the target value changes when the individual gets promoted.
I have no Table in SQL datasource that contains individual target value.
How can I achieve this, compare individual target with sales amount that automatically changes with individual promotion?🙂
Cheers.
Hi schoden ,
you can create such a calculated table.
Please refer to my .pbix file.
The target sales amount always changes dynamically with the latest actual sales.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
