Forum Discussion
Weeknum as per Calendar
I need each quarter week number, I have filtered = '26-Q1' 1-13 Week number starting from Monday current week = 11 (as per today) incase 30th March 2026 is Monday half month (max. days) fall u...
Anonymous
it's sum ,so it sums up all the weeknum.
you can try something like this
Measure = maxx(FILTER('Date','Date'[Date]=today()),'Date'[QuarterWeekNumber])in my DAX, it shows week 11, if you want to show 10, you need to adjust the DAX codingwhat if select other quarter, what's the expected output?
Anonymous
pls see if this is what you want
QuarterWeekNumber =
VAR ThisDate = 'Date'[Date]
VAR ThisQuarter = QUARTER ( ThisDate )
VAR ThisYear = YEAR ( ThisDate )
VAR a =
DATE (
ThisYear,
1 + ( ThisQuarter - 1 ) * 3,
1
)
-- First Monday in that quarter
VAR FirstMondayInQuarter =
CALCULATE (
MIN ( 'Date'[Date] ),
FILTER (
ALL ( 'Date' ),
'Date'[Date] >= a
&& 'Date'[Date] < EDATE ( a, 3 )
&& WEEKDAY ( 'Date'[Date], 2 ) = 1
)
)
RETURN
INT ( ( ThisDate - FirstMondayInQuarter ) / 7 ) + 2
quarter = if ('Date'[QuarterWeekNumber]>13,QUARTER('Date'[Date])+1,QUARTER('Date'[Date]))
how can I read this if I selected Quarter = 1, week number should be = 10 (as per today 10th Mar) but showing = 634
Anonymous
it's sum ,so it sums up all the weeknum.
you can try something like this
Measure = maxx(FILTER('Date','Date'[Date]=today()),'Date'[QuarterWeekNumber])in my DAX, it shows week 11, if you want to show 10, you need to adjust the DAX codingwhat if select other quarter, what's the expected output?