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.
What functions do i have to look at? Thanks in advance.
Go to Solution.
@DannyVerdel , your description is too ambiguous, so I make a guess,
= Table.AddColumn(Source, "Period", each Number.RoundUp([Week]/4))
View solution in original post
This is exactly what i mean. Thanks.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!