Week number with in Quarter in column

[Puja]

Hello All,

How can I get the  Date format like this? TIA

[Puja]

Thank you SO MUCH @kitgo2.

I need to get weeks by quarter .

  I need to show 13 weeks in th Visual for each quarter (ex: for Quarter 3 (April-June ))

Previous weeks with - and future weeks with + sign like the way in this screen shot. TIA

[v-xiaotang · Accepted solution]

Hi @Puja 

Thanks for reaching out to us.

>>   I need to show 13 weeks in th Visual for each quarter (ex: for Quarter 3 (April-June ))

You can try this,

(1) create a calendar table

calendar = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

create a week column, 

week = WEEKNUM('calendar'[Date])

(2) create the 2 measures,

week = MAXX(FILTER('calendar','calendar'[Date]=MIN('Table'[Date])),[week])

Measure = 
var _currentDate=DATE(2022,5,23)
var _currentWeek= MAXX(FILTER('calendar','calendar'[Date]=_currentDate),[week])
return IF([week]>_currentWeek-6 && [week]<_currentWeek+6,IF(([week]-_currentWeek)>0, "Week +"&([week]-_currentWeek),"Week "&([week]-_currentWeek)))

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Puja]

Thank you so much @v-xiaotang 

 This works perfoct with the static date 
var _currentDate=DATE(2022,5,23) , when i added Today(), it s not working . I want it to be dynamic .

If its current week then "Current", past weeks  - and future weeks with + symbol with in the quarter.

This is past screenshot example.

TIA

[kitgo2]

Week# = if ('Calendar'[Date] = TODAY(),"Current", if (year(Today()) = Year('Calendar'[Date]),"Week " & ( WEEKNUM('Calendar'[Date],2) - WEEKNUM(today(),2)) ,"Week " & ( WEEKNUM('Calendar'[Date],2) - (WEEKNUM(today(),2) + 52))))

Start of week = if(WEEKDAY('Calendar'[Date],2) = 1, 'Calendar'[Date]) -- filter visual to only select non blanks or filter out only mondays

Format = 'Calendar'[Week#] & " " & UNICHAR(10) &
FORMAT('Calendar'[Date],"dd-mmm") & UNICHAR(10) & "Monday - Sunday"