i am experimenting with DAX, VALUES() creates a table of unqiue values. if i use UniqueDates = Values(Sales[orderdate]) and drag this on a matrix or table i get the error, "a table of multiple values was suplied where a single value was expected".
i know I used a measure to create this, but i also assumed by 'dont summarize' it would be a Dimension and I could use it as a list of values.
it VALUES() creates a table or column of unique values why do I get an error? thanks for any help understanding