cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

number of the week in the month, starting on Thursday

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?

 

 
 

sem.png

 

1 ACCEPTED SOLUTION
Super User I
Super User I

Hi @rssilva_22 ,

 

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

 

Two different options:

 

- Power Query Editor --> Date.WeekOfMonth

 

Payeras_BI_0-1611300391761.png

 

 

 

 

 

 

 

- Calculated column in DAX:

 

Payeras_BI_1-1611301394295.png

 

 

Regards,


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos :winking_face:
Mallorca, Spain

View solution in original post

4 REPLIES 4
Super User I
Super User I

Hi @rssilva_22 ,

 

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

 

Two different options:

 

- Power Query Editor --> Date.WeekOfMonth

 

Payeras_BI_0-1611300391761.png

 

 

 

 

 

 

 

- Calculated column in DAX:

 

Payeras_BI_1-1611301394295.png

 

 

Regards,


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos :winking_face:
Mallorca, Spain

View solution in original post

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.

Solution Sage
Solution Sage

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. 

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.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.