Forum Discussion

mazwro's avatar
mazwro
Helper II
2 years ago
Solved

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

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 :

 

Need Help

4 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    2 years ago

    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's avatar
      mazwro
      Helper II
      2 years ago

      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

       

Related content