Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 months ago
Solved

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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 months ago

    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 coding
     

    what if select other quarter, what's the expected output?

ryan_mayu's avatar
ryan_mayu
Super User
5 months ago

Anonymous 

not clear about your request, if the week count starts from 2026/1/1, then 3/30 should be week 13. Then it falls to Q2?

could you pls provide the expected output for the whole year date? And elaborate this.

Anonymous's avatar
Anonymous
Not applicable
5 months ago

if Q2 then 1-13 week, Q3 then 1-13 like this

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 months ago

    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]))
     
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 months ago

      how can I read this if I selected Quarter = 1, week number should be = 10 (as per today 10th Mar) but showing = 634

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        5 months ago

        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 coding
         

        what if select other quarter, what's the expected output?