Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Shuvo
New Member

Target VS Achievement Calculation

Hello, I am new user of Power Bi Tool. I know how to export or import data and make visualization. But now I have faced a problem when I want to create a chart about target vs achivement. For example, I have 4 sales person.  Their annual sales target are given below - 

EMP -    Annual Sales Target -   Monthly Sales target

EMp 1 -       100-                    -        8.33

EMP 2 -        120                    -           10

EMP 3 -         240                    -           20

EMP 4 -         560                    -           46.66

 

How I would like to create a table in power BI to calculate the achivement in power BI monthly basis of target vs achievement. For exapmple - EMP 2 has sold 10 in January, 15 in February, 50 in march. 

 

So the table will be like below - 

 

EMP -    Annual Sales Target -   Monthly Sales target - Jan Sales - Jan Achv % - Feb Sales - Feb Achv % - YTD Sales - YTD Ach %

EMP 2 -        120                    -           10                       -  10          - 100 %        - 15             -  150%         -   25           -   125 % 

 

the calculation must calculate ytd target and achivement automatically. how to do it?

 

 

2 REPLIES 2
AbbasG
Memorable Member
Memorable Member

Hi @Shuvo 

I have recently posted a video on this topic.

 

It might guide you in the right direction.

 

https://youtu.be/d4UKMHzSm5k

Shuvo
New Member

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.