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?

grazitti_sapna's avatar
grazitti_sapna
Super User
5 months ago

Hi Anonymous ,

 

I believe you are trying to create a measure, You need to create a calculated column instead.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 months ago

we created calculated column as mentioned earlier but does not work