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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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