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

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

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

    • 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
      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        2 years ago

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