Forum Discussion
Issue in DAX Query
I am trying to create a calculated column in DAX Query view ( not in power Query Window) .Its simple , columns should get value as weekday or weekend , depending on day of the week. Find below the ...
Hi abhinav_k18
Just as Greg_Deckler said that this dax should work fine.
If you can share your data(exclude sensitive data) or create some sample data, so that we can help you better.
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-zhengdxu-msft,
The data i have is like this , i want to create a new calculated column [Day Type], which will have 2 distinct type of values , Weekend if (day number of week is 1 or 7) , otherwise Weekday.
Kindy Help
| ID | DayNumberOfTheWeek |
| 1 | 1 |
| 2 | 7 |
| 3 | 4 |
| 4 | 2 |
| 5 | 6 |
| 6 | 3 |
| 7 | 1 |
| 8 | 5 |
| 9 | 2 |
| 10 | 1 |
