Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Legend_11
Resolver I
Resolver I

Month Name from Week Number

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

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
SamInogic
Super User
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]

SamInogic_0-1693830744027.png

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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

View solution in original post

2 REPLIES 2
SamInogic
Super User
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]

SamInogic_0-1693830744027.png

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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/
amitchandak
Super User
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]
)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors