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

AllisonKennedy  yes Alison you got me 100% . I am trying to create/store data in power BI. 

Currently I have created a dax  (values are static )of Individual target that compares with sales amount. 

 

I wanted to make individual target dynamic that changes with individual promotion date. 

 

Thanks ,  I will research more on it.

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Good luck schoden 

 

You will need to choose another application to store the data (Excel is easy). Power BI can only perform calculations on data that already exists in the data model.