Forum Discussion

arjun123's avatar
arjun123
Regular Visitor
3 years ago

Urgent: Powerbi Challenge

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 : [email protected] to receive

Amazon gift voucher worth USD 20 

Thank you

 

 

 

 

Show and Tell

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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