Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I manually set and input a weekly income target for our team. I have a measure set up which allows me to use a gauge visual to demonstrate to the team their cumulative progress towards the target over the course of the week.
What I would like to do however, is to make a daily apportionment of the weekly target that I have set, so that I can use a Line Chart to show them if they are ahead of or behind the target on a daily basis.
The daily apportionment of the weekly target should be based on historical trends of what proportion of the overall weekly income has been generated on a daily basis. (It wouldn’t work to just split the weekly target figure down equally across the weekdays as we have some very clear peak days in the week).
Happy to share any information that might be required to get some assistance…far beyond my capability level at the minute!
Solved! Go to Solution.
You may try measure below to calculate the percentage.
Measure =
VAR d =
SELECTEDVALUE ( 'Calendar'[Date] )
VAR w = 10
RETURN
DIVIDE (
CALCULATE (
SUM ( 'Table'[Value] ),
DATEDIFF ( 'Table'[Date], d, WEEK ) >= 1
&& DATEDIFF ( 'Table'[Date], d, WEEK ) <= w,
'Table'[Weekday] = WEEKDAY ( d )
),
CALCULATE (
SUM ( 'Table'[Value] ),
DATEDIFF ( 'Table'[Date], d, WEEK ) >= 1
&& DATEDIFF ( 'Table'[Date], d, WEEK ) <= w
)
)
You may try measure below to calculate the percentage.
Measure =
VAR d =
SELECTEDVALUE ( 'Calendar'[Date] )
VAR w = 10
RETURN
DIVIDE (
CALCULATE (
SUM ( 'Table'[Value] ),
DATEDIFF ( 'Table'[Date], d, WEEK ) >= 1
&& DATEDIFF ( 'Table'[Date], d, WEEK ) <= w,
'Table'[Weekday] = WEEKDAY ( d )
),
CALCULATE (
SUM ( 'Table'[Value] ),
DATEDIFF ( 'Table'[Date], d, WEEK ) >= 1
&& DATEDIFF ( 'Table'[Date], d, WEEK ) <= w
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
64 | |
59 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |