Forum Discussion

RodrigoTXRA's avatar
RodrigoTXRA
Icon for Helper I rankHelper I
8 years ago
Solved

YTD performance

Hi All I'm trying to replicate a calculation I have in excel into Power BI. Long story short, I have a table which display what the performance is for each month (see screen shots) and a second...
  • parry2k's avatar
    parry2k
    8 years ago

    RodrigoTXRAHere is something I put together to give you an idea, logically you should have a FIscal Date DImension in model for time intelligence and this kind of calculation, but I guess this will get you started.

     

    Cheers!!!

    P

RodrigoTXRA's avatar
RodrigoTXRA
Icon for Helper I rankHelper I
8 years ago

parry2k After applying the changes to the other templates I realised that whenever I have two people on the list (The dataset I sent you only had one person), the measures sum up for both users.

 

i.e. see screen shot below:

It picks up the correct % column, however, on the YTD Avg HR column, it is adding up the percentage for user 1 and user 2

Would you have any thoughts? Or are able to replicate the issue on your end?

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

RodrigoTXRAwe need to update DAX formul to seperate by user, I will get back to you soon.