cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## Month Name from Week Number

 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

1 ACCEPTED SOLUTION
Super User

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

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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/
2 REPLIES 2
Super User

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

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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/
Super User

@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]
)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.