Share via

I keep getting an error message

pomanski 1 Reputation point
2022-02-07T22:28:57.993+00:00

Date
1/1/2020
1/2/2020
1/3/2020
1/4/2020
1/5/2020
1/6/2020
1/7/2020
1/8/2020
1/9/2020
1/10/2020
1/11/2020
1/12/2020
1/13/2020
1/14/2020
1/15/2020
1/16/2020
1/17/2020
1/18/2020
1/19/2020
1/20/2020
1/21/2020
1/22/2020

New user. The above table set it up as a date table when I try to add another column using =Year(Date)

I get the following error and I don't know what I am doing wrong. I tried Date[Date] and I get and error message also.

"Calculation error in measure 'Date'[Year]: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Community Center | Not monitored
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.