Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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....
Solved! Go to 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!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |