Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
EmilijaN
Helper I
Helper I

Week counter

Hello, 

 

I need help with creating a code to find how many days of the weeks belong to One or another Month.

 

Example:

                                                        New column

1/31/2022 January    week day 1      Feb
2/1/2022   February  week day 2      Feb
2/2/2022   February  week day 3      Feb
2/3/2022   February  week day 4      Feb
2/4/2022   February  week day 5      Feb
2/5/2022   February  week day 6      Feb
2/6/2022   February  week day 7      Feb

 

If there is more than 4 days in the same Month than all that week I need to be in that Month. In the example all this days have to be in February .

 

Any suggestions?

3 REPLIES 3
EmilijaN
Helper I
Helper I

The month that has it more times in a week always wins.  Then the output will be January for whole week.

pls check if this is what you want





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

what if no more than 4 days? what's the output for the first row?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.