Forum Discussion
4 week periods based on weeks
Hello everyone, I have a date table and want to create a column for the period. 1 period = 4 weeks. So the table would have to look like this.
| Week | Period |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
What functions do i have to look at? Thanks in advance.
Anonymous , your description is too ambiguous, so I make a guess,
= Table.AddColumn(Source, "Period", each Number.RoundUp([Week]/4))
2 Replies
CNENFRNLCommunity Champion
Anonymous , your description is too ambiguous, so I make a guess,
= Table.AddColumn(Source, "Period", each Number.RoundUp([Week]/4))