topic Re: Issue in DAX Query in DAX Commands and Tips

Issue in DAX Query

abhinav_k18 — Mon, 06 May 2024 19:18:45 GMT

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?

Re: Issue in DAX Query

Greg_Deckler — Mon, 06 May 2024 20:35:01 GMT

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

Re: Issue in DAX Query

Anonymous — Tue, 07 May 2024 06:40:49 GMT

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.

Re: Issue in DAX Query

abhinav_k18 — Tue, 07 May 2024 16:14:23 GMT

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

Re: Issue in DAX Query

Greg_Deckler — Tue, 07 May 2024 16:17:00 GMT

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