The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[mazwro]

I am reading though support and cannot see a save for my issue. Can someone help what it means please?

I am trying to create a date selector table, unlinked to other tables and it looks as below. The error I am getting is this:

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Date Aggregation parameters measure = {
    ("WEEK", NAMEOF('date selector'[WeekRange]), 0),
    ("MONTH", NAMEOF('date selector'[MonthRange]), 1),
    ("QUARTER", NAMEOF('date selector'[QuarterRange]), 2)
}

 the table i s a standard date table :

[AntrikshSharma]

@mazwro You might be in the context of a measure? Show an image of the table where it throws the error.

"I am truing to create a date selector table" but in your DAX you're using 'date selector' what's up with that?

[mazwro]

Thanks for the answer.

I want to create a slicer, or an aggregation selector which aggregates my date by week, month or a quarter, like below:.
In an example I am using this slicer is create like so:

Date Aggregation parameters = {
    ("DAY", NAMEOF('Date table'[DateFormatted]), 0),
    ("WEEK", NAMEOF('Date table'[WeekRange1]), 1),
    ("MONTH", NAMEOF('Date table'[MonthYearFormatted]), 2)
}

I am rewriting it to get a quarter as well. It is a new column, not a measure

In the screenshot following, I am trying to create the same aggregator in both tables: one is a blank one, one is a normal date table

[Anonymous · Accepted solution]

Hi @mazwro ,

It seems that you want to add a new field to the field parameter, and the easiest way to do this is to delete it and then recreate it.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[AntrikshSharma]

@mazwro you're creating a calculated column and not a calculated table.