Forum Discussion

schoden's avatar
schoden
Post Partisan
5 years ago
Solved

Dynamic Individual Target

Hi Community,    Please help or share any resources related to the case.   I have  sales table on monthly basis( employe id, sales id, emp name, sale Date, sales amount )    I want to create a ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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 Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

schoden's avatar
schoden
Post Partisan
5 years ago

amitchandak  

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. 

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.