Forum Discussion
Wanted to Show Month Week Number ( For Ex :- June Week 1, June Week 2 .. etc , March Week 1 )
Hi Team, I have date column in Power BI which shows every Monday of the week, Now I wanted to create a column which will show June Week 1, June Week 2 ... December Week 1. If i use Weeknum th...
Anonymous
Add this as a new columnMonth-Week = VAR _DAY = DAY([Date]) RETURN SWITCH( TRUE(), _DAY >= 1 && _DAY <= 7, "Week 1", _DAY >= 8 && _DAY <= 14, "Week 2", _DAY >= 15 && _DAY <= 21, "Week 3", _DAY >= 22 && _DAY <= 28, "Week 4", "Week 5" )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
Fowmy
Super User
Super UserAnonymous
Add this as a new column
Month-Week =
VAR _DAY = DAY([Date]) RETURN
SWITCH( TRUE(),
_DAY >= 1 && _DAY <= 7, "Week 1",
_DAY >= 8 && _DAY <= 14, "Week 2",
_DAY >= 15 && _DAY <= 21, "Week 3",
_DAY >= 22 && _DAY <= 28, "Week 4",
"Week 5"
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š