topic number of the week in the month, starting on Thursday in DAX Commands and Tips

number of the week in the month, starting on Thursday

Anonymous — Thu, 21 Jan 2021 20:03:29 GMT

Hi.

I have a DCalendar table with a field to identify the day of the week in the month.
I need her to start counting the week from Thursday.

Example S1 from December 2020 (days 1, 2 and 3) - S2 (from 4 to 10) and so on!

Can anyone help me do the DAX for this?

StefanoGrimaldi — Fri, 22 Jan 2021 01:19:45 GMT

hey,

you could add a new column with some nested ifs,

new column = if(weekday(date) = 5, "S2",if(weekday(date) = 6,"S2",... and so on

number 5 of the week its thursday

if this helped or resolve your problem give some kudos and mark as solutions for others to find.

Anonymous — Fri, 22 Jan 2021 03:05:49 GMT

hello StefanoGrimaldi

Thanks for the feedback, but I didn't understand how to apply it.
Can you set up an example?

if you put S2 for every number 5 every Thursday will be S2 and that's not what I need.

Payeras_BI — Fri, 22 Jan 2021 07:46:39 GMT

Hi Anonymous ,

I believe from your screenshot you want you week to start on Friday (04/12/2020).

Two different options:

- Power Query Editor --> Date.WeekOfMonth

- Calculated column in DAX:

Regards,

Anonymous — Fri, 22 Jan 2021 13:38:25 GMT

Dear Payeras_BI

Thank you for your feedback and time in doing the example.

It was just what I needed.

I'm new to powerquery and DAX, I did a lot of research before posting on the forum and was not getting it.
I will study the commands that you put.