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.

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

schoden  If I'm understanding correctly, you're looking to create/store data? Power BI is designed for reporting on existing data, not so great at collecting/storing information. Where do your sales figures come from? You can use Power Automate to automate target change with promotion of sales person (or based on previous month sales figures), and lots of choices for where to store that information: Excel, SharePoint List, CDS, Azure, etc. 

 

Does that help at all? Or just confuse matters?

  • 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.