Forum Discussion

Rsanjuan's avatar
Rsanjuan
Advocate III
9 years ago
Solved

Display current week time frame

Hi,   I have a date table as follows:   Date = ADDCOLUMNS(CALENDAR(DATE(2000,1,1),DATE(2025,12,31)), "DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ), "Year", YEAR ( [Date] ), "Monthnumber", FOR...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi Rsanjuan,

     

    The DAX formula below will work for your requirement.

    First create a column in your date table
    Weeknumber = WEEKNUM('Date'[Date])

    Then create a measure

    Measure = FORMAT(LOOKUPVALUE('Date'[Date],'Date'[DayOfWeekNumber],1,'Date'[Weeknumber],WEEKNUM(TODAY()),'Date'[Year],YEAR(TODAY())),"MMMM DD") & " - " & FORMAT(LOOKUPVALUE('Date'[Date],'Date'[DayOfWeekNumber],7,'Date'[Weeknumber],WEEKNUM(TODAY()),'Date'[Year],YEAR(TODAY())),"MMMM DD")

     

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Hi Rsanjuan,

 

The DAX formula below will work for your requirement.

First create a column in your date table
Weeknumber = WEEKNUM('Date'[Date])

Then create a measure

Measure = FORMAT(LOOKUPVALUE('Date'[Date],'Date'[DayOfWeekNumber],1,'Date'[Weeknumber],WEEKNUM(TODAY()),'Date'[Year],YEAR(TODAY())),"MMMM DD") & " - " & FORMAT(LOOKUPVALUE('Date'[Date],'Date'[DayOfWeekNumber],7,'Date'[Weeknumber],WEEKNUM(TODAY()),'Date'[Year],YEAR(TODAY())),"MMMM DD")

 

 

Regards,

Charlie Liao