Forum Discussion
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
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 TeamIf 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
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
mazwro you're creating a calculated column and not a calculated table.