Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |