Forum Discussion

Legend_11's avatar
Legend_11
Resolver I
2 years ago
Solved

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...
Interesting Links
Need Help
  • SamInogic's avatar
    SamInogic
    2 years ago

    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 [email protected]

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

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

SamInogic's avatar
SamInogic
Super User
2 years ago

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 [email protected]

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

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