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/

amitchandak's avatar
amitchandak
Super User
2 years ago

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