Month Name from Week Number

[Legend_11]

WeekNumber	Month (calculated column)
1	September (current week)
2	September
3	September
4	September
5	October
6	October
7	October
8	October
9	November
10	November

I am having a week number , I need to tag the week number 1 to current week (from there current month).

Anyone help me in creating this calculated column

[SamInogic · Accepted solution]

Hi @Legend_11 ,

You can also try below DAX to create a calulated Date column as 

CalculateDate = var todayDate = NOW()

var calDate = DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) + DataTbl[WeekNumber] * 7)

return calDate

Create a Month column with below DAX,

Month = DataTbl[CalculateDate].[Month]

Thanks!

Inogic Professional Services

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[amitchandak]

@Legend_11 , You can use this kind of logic

Week Type =
var _st = today() +-1*WEEKDAY(today() ,2)+1
var _end = today() + 7-1*WEEKDAY(today(),2)
return
Switch( True(),
[Date] >= _st && [Date] <= _end ,"This Week" ,
[Date] >= _st-7 && [Date] <= _end -7,"Last Week" ,
[Week Name]
)