Back
Follow this measure
//calculated columns in calendar tableWeekday = WEEKDAY('calendar table'[Date],2) Weeknum = WEEKNUM('calendar table'[Date], 2) Weeknum by month = CALCULATE( COUNT('calendar table'[Weeknum]), FILTER( 'calendar table', 'calendar table'[Date].[MonthNo] = EARLIER('calendar table'[Date].[MonthNo]) && 'calendar table'[Weekday] = 7 ))Start of week = CALCULATE( MAX('calendar table'[Date]), FILTER( 'calendar table', 'calendar table'[Weeknum] = EARLIER('calendar table'[Weeknum]) && 'calendar table'[Weekday] = 1 )) //measureWeekly Target = MAX(Sheet9[Target]) / MAX('calendar table'[Weeknum by month])
//calculated columns in calendar table
Weekday = WEEKDAY('calendar table'[Date],2)
Weeknum = WEEKNUM('calendar table'[Date], 2)
Weeknum by month =
CALCULATE(
COUNT('calendar table'[Weeknum]),
FILTER(
'calendar table',
'calendar table'[Date].[MonthNo] = EARLIER('calendar table'[Date].[MonthNo])
&&
'calendar table'[Weekday] = 7
)
Start of week =
MAX('calendar table'[Date]),
'calendar table'[Weeknum] = EARLIER('calendar table'[Weeknum]) && 'calendar table'[Weekday] = 1
//measure
Weekly Target = MAX(Sheet9[Target]) / MAX('calendar table'[Weeknum by month])
Want to learn more about Power Bi, Refer: Power Bi Training
31k questions
32.8k answers
501 comments
693 users