Hi Community
I'm learning DAX from @MattAllington 's SuperCharge PBI (p 148) & it's great but I'm having a problem creating the following calc col on Customers in AdventureWorks:
AgeGroup = CALCULATE(
VALUES(AgeBands[Band]),
FILTER(AgeBands,
Customers[Age] >= AgeBands[Low]
&& Customers[Age] < AgeBands[High]
)
)
I'm getting the error: "A single value for column 'Age' in table 'Customers' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
Customers[Age] is not being recognized by intellisense. This is also a calc col (working ok) with the formulae:
Age = ROUNDDOWN((DATE(2003,1,1) - Customers[BirthDate])/365,0) - data type & format: whole no.
I've also referred to Marco Russo's https://www.sqlbi.com/articles/grouping-transactions-by-age-of-customers-in-dax/ & am having the same problem.
thanks for any advice.
Peta
