Forum Discussion

abhinav_k18's avatar
abhinav_k18
New Member
2 years ago

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 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?

4 Replies

    • abhinav_k18's avatar
      abhinav_k18
      New Member
      2 years ago

      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 

       

       

      IDDayNumberOfTheWeek
      11
      27
      34
      42
      56
      63
      71
      85
      92
      101