topic Re: Week number with in Quarter in column in DAX Commands and Tips

Week number with in Quarter in column

Puja — Sun, 26 Jun 2022 20:56:29 GMT

Hello All,

How can I get the Date format like this? TIA

Re: Week number with in Quarter in column

kitgo2 — Sun, 26 Jun 2022 23:48:37 GMT

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"

Re: Week number with in Quarter in column

Puja — Mon, 27 Jun 2022 03:43:30 GMT

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

Re: Week number with in Quarter in column

v-xiaotang — Wed, 29 Jun 2022 06:07:03 GMT

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.

Re: Week number with in Quarter in column

Puja — Fri, 08 Jul 2022 15:32:31 GMT

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