Forum Discussion

JBESRI's avatar
JBESRI
Regular Visitor
2 years ago
Solved

Target change during the year

Hi all!   I'm looking for a solution for a problem I have. We are writing all work hours and some of those hours are for our customers. Some collagues have a target on how many % of their written h...
Need Help
  • JBESRI's avatar
    JBESRI
    2 years ago

    Above didn't help, but I found a solution.

    Made a table out of all the worked hours by day and employee, So i have in the columns Employee, day and in other columns for each type of work a column (pivot column). From there i needed the dax formula to retrieve the target by day.

    target =

    VAR CurrentDate = worked hours[date]
    RETURN
        CALCULATE (
            MAX ( Targettable ),
            FILTER (
                'AA targettest',
                'AA targettest'[Column1] = worked hours[Employee] &&
                'AA targettest'[Startdate] <= CurrentDate &&
                'AA targettest'[Enddate] >= CurrentDate
            )
        )
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you johnbasha33  for your prompt reply.

Hi JBESRI  ,
May I ask if you have tried the suggestions above? If the suggestion helped you, you might consider marking it as a solution. If the problem has not yet been solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.