Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calendar data update

Hi Team,   What do I need to do to a)  Add week to this dax code (Monday - Sunday) b) Add a piece of code to take account of today's date date_to   Calendar = VAR __MIN =     DATE ( 2022, 1...
Need Help
  • speedramps's avatar
    speedramps
    2 years ago

    Simply add this new calculated column to your data table to get the week number

     

     

    Week = 
// week starts Monday and ends Sunday
YEAR('Calendar'[Date]) 
& "-" &
FORMAT(WEEKNUM('Calendar'[Date],2),"00")

     

     

    Please click "accept solution" and the thumbs up buttons 

speedramps's avatar
speedramps
Super User
2 years ago

Simply add this new calculated column to your data table to get the week number

 

 

Week = 
// week starts Monday and ends Sunday
YEAR('Calendar'[Date]) 
& "-" &
FORMAT(WEEKNUM('Calendar'[Date],2),"00")

 

 

Please click "accept solution" and the thumbs up buttons