Daywise and YTD percentages based on their respective targets

[Anonymous]

Hi,

My Data looks like below.

July 3rd, 4th, 9th and 10th weekoffs. Remaining blank fields shows, they are on leave. Based on this, I need their target percentages.

In this I need daywise% and YTD%. Can you please tell me, how to calculate.

Thanks in advance....

[Anonymous]

Tnq @Tanushree_Kapse 

[Tanushree_Kapse · Accepted solution]

Hi @Anonymous ,
I would suggest you to unpivot the date columns.
Make this one column of Dates and a different colmn of Values.
Then, create your YTD measures.
1. Ytd= TOTALYTD(SUM(Table(Values)),Table(Dates))
2. Ytd %= DIVIDE(Ytd, Target).....Format this to precentage.
3. daywise%= DIVIDE(Values, Target).....Format this to precentage.

I believe this is what you need.
Kudos are appreciated!