Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Last weekend in Month

Hi,

I'm not able to find a solution. I'm trying to get the last Saturday in month.

For example, July 2022 Sat ended on the 30th and Nov Saturday ended on 26th.

 

How do you calculate and get the last Saturday in month?  

 

 JULY 2022
 SMTWTFS
 3456789
 10111213141516
 17181920212223
 24252627282930

 

 NOVEMBER 2022
 SMTWTFS
 303112345
 6789101112
 13141516171819
 20212223242526
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Try:

    Measure = 
  VAR __Date = MAX('Table'[Date])
  VAR __SoM = DATE(YEAR(__Date),MONTH(__Date),1)
  VAR __EoM = EOMONTH(__Date,0)
  VAR __Table = 
    ADDCOLUMNS(
      CALENDAR(__SoM, __EoM),
      "__WeekDay", WEEKDAY([Date],1)
    )
  VAR __Result = MAXX(FILTER(__Table, [__WeekDay] = 7),[Date])
RETURN
  __Result

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous Try:

    Measure = 
  VAR __Date = MAX('Table'[Date])
  VAR __SoM = DATE(YEAR(__Date),MONTH(__Date),1)
  VAR __EoM = EOMONTH(__Date,0)
  VAR __Table = 
    ADDCOLUMNS(
      CALENDAR(__SoM, __EoM),
      "__WeekDay", WEEKDAY([Date],1)
    )
  VAR __Result = MAXX(FILTER(__Table, [__WeekDay] = 7),[Date])
RETURN
  __Result