Week counter

Question

Hello,&nbsp;&nbsp;I need help with creating a code to find how many days of the weeks belong to One or another Month.&nbsp;Example:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; New column1/31/2022 January&nbsp; &nbsp; week day 1&nbsp; &nbsp; &nbsp; Feb2/1/2022&nbsp; &nbsp;February&nbsp; week day 2&nbsp; &nbsp; &nbsp; Feb2/2/2022&nbsp; &nbsp;February&nbsp; week day 3&nbsp; &nbsp; &nbsp; Feb2/3/2022&nbsp;&nbsp;&nbsp;February&nbsp; week day 4&nbsp; &nbsp; &nbsp; Feb2/4/2022&nbsp;&nbsp; February&nbsp; week day 5&nbsp; &nbsp; &nbsp; Feb2/5/2022&nbsp; &nbsp;February&nbsp; week day 6&nbsp; &nbsp; &nbsp; Feb2/6/2022&nbsp;&nbsp; February&nbsp; week day 7&nbsp; &nbsp; &nbsp; Feb&nbsp;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 .&nbsp;Any suggestions?

ryan_mayu · Answer

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

emilijan · Answer

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

ryan_mayu · Answer

pls check if this is what you want

Forum Discussion

Week counter

3 Replies

Related content

Incremental counter per day

List.Accumulate & Table.AddColum with Iteration Step Counter

Week over week measure

Visitation Counter

ISO week