Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
My dataset has no date column, but contains Dayofweek from Number 1 to 7.
I want to Create a Column that Returns Monday to Friday instead.
I had to use IF then Function (like shown in the image below) to get this. But i Know there is a better and more efficient way to get this using a simple Dax formula.
Probably, takes the Number like 1 and Return Monday in a column. i would appreciate if i could get your suggestions
Solved! Go to Solution.
Hi @driplytics ,
As @tamerj1 mentioned before, you can use switch like this:
Weekday =
SWITCH (
[DayOfWeek],
1, "Monday",
2, "Tuesday",
3, "Wedensday",
4, "Thursday",
5, "Friday",
6, "Saturday",
7, "Sunday"
)
Output:
Also, you can create a new table like this:
Table =
SELECTCOLUMNS (
CALENDAR ( TODAY (), TODAY () + 6 ),
"Weekday", FORMAT ( [Date], "dddd" ),
"DayOfWeek", WEEKDAY ( [Date], 2 )
)
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @driplytics ,
As @tamerj1 mentioned before, you can use switch like this:
Weekday =
SWITCH (
[DayOfWeek],
1, "Monday",
2, "Tuesday",
3, "Wedensday",
4, "Thursday",
5, "Friday",
6, "Saturday",
7, "Sunday"
)
Output:
Also, you can create a new table like this:
Table =
SELECTCOLUMNS (
CALENDAR ( TODAY (), TODAY () + 6 ),
"Weekday", FORMAT ( [Date], "dddd" ),
"DayOfWeek", WEEKDAY ( [Date], 2 )
)
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
25 | |
11 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
13 | |
12 | |
10 | |
6 |