Urgent: Powerbi Challenge

[arjun123]

Hi, 

     I have a sample file in which all the data modeling has been done correctly.

PLEASE GO THROUGH the files BEFORE ANSWERING THE QUESTIONS.

1) What you need to do now is to: Create a measure that gives us the names of the employees who have  exceeded the target.

2) Show by how much % has the revenue crossed the target (for those employees who have exceeded the target)

3)  Show trend in revenue & target Quarter-on-Quarter

https://github.com/arjunrdk1/Powerbi-Transformation-Challenge 

Let me know what all steps need to be followed for answering the above question 

You can also share the solution(Dashboard with files) at my email id : arjun.student123@gmail.com to receive

Amazon gift voucher worth USD 20 

Thank you

[v-yanjiang-msft]

Hi @arjun123 ,

For the problem "gives us the names of the employees who have  exceeded the target." How do you define if an employee has exceeded the target. As you can see, for an employee, some values exceeded the target but some did't. Also, there're many company tickers for each employee. Please clarify the calculation logic.

Best regards,

Community Support Team_yanjiang