topic Month start from Friday and end on last Thursday in DAX Commands and Tips

Month start from Friday and end on last Thursday

ajisharavind_99 — Fri, 24 Feb 2023 06:30:24 GMT

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.

Re: Month start from Friday and end on last Thursday

FreemanZ — Fri, 24 Feb 2023 07:31:35 GMT

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

)

Re: Month start from Friday and end on last Thursday

CNENFRNL — Fri, 24 Feb 2023 08:57:41 GMT

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

Re: Month start from Friday and end on last Thursday

ajisharavind_99 — Fri, 24 Feb 2023 09:28:42 GMT

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

Re: Month start from Friday and end on last Thursday

ajisharavind_99 — Fri, 24 Feb 2023 09:29:17 GMT

Thank you CNENFRNL

Re: Month start from Friday and end on last Thursday

tamerj1 — Fri, 24 Feb 2023 11:56:55 GMT

Another solution for reference