Issue in DAX Query

[abhinav_k18]

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 code snippet 

DEFINE COLUMN

'Calendar'[Day Type] =

IF(

    'Calendar'[DayNumberOfWeek] = 1 || 'Calendar'[DayNumberOfWeek] = 7,

    "Weekend",

    "Weekday"

)

Evaluate

SUMMARIZECOLUMNS(

    'Calendar'[Day Type]

)
The error is 'UNEXPECTED COLUMN Column'
Can anyone guide?

[Anonymous]

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.

[abhinav_k18]

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

[Greg_Deckler]

@abhinav_k18 @Anonymous In DAX Query view I immediately get an error just trying DEFINE COLUMN.

[Greg_Deckler]

@abhinav_k18 Not sure DAX Query View is fully baked. That query seems to work in DAX Studio but not in DAX Query View.