Month start from Friday and end on last Thursday

[ajisharavind_99]

Hi, 

I am looking for a solution for my Power BI project to identify the last Friday of the previous month as the start of the month and the last Thursday of the current month as the month's end 🙄. If the month ends on 25, the following month will begin on 26. Please see the screenshot for the expected result.

[tamerj1]

Another solution for reference

[CNENFRNL · Accepted solution]

For fun only, very simple case for the powerful Excel worksheet formula,

[ajisharavind_99]

Thank you @CNENFRNL 

[FreemanZ]

hi @ajisharavind_99 

try to add a calculated column like:

MonthColumn =

VAR _month = MONTH(DateTable[Date])

VAR _lastfriday =

MAXX(

   FILTER(

      DateTable,

      WEEKDAY(DateTable[Date], 2)=5

         &&MONTH(DateTable[Date]) = _month

    ),

   DateTable[Date]

)

RETURN

IF(

   [Date] >= _lastfriday,

   FORMAT(EDATE([Date], 1), "mmm-yy"),

   FORMAT([Date], "mmm-yy")

)

[ajisharavind_99]

Thanks @FreemanZ 
Only in December 2022 was an issue found, which begins on Thursday rather than Friday.