Forum Discussion
churn
Hi AlB,
Thats some sweet DAX code thank you for the prompt reply. Having some issues though. Anything you could do with the following
ListCustomers1 =VAR T2017 = CALCULATETABLE ( VALUES (Renewals[Account_ID]), Renewals[Renewal Year] = 2017 ) VAR T2018 = CALCULATETABLE ( VALUES ( Renewals[Account_ID]), Renewals[Renewal Year] = 2018 ) RETURN (EXCEPT ( T2017, T2018 ))ErrorCalculation error in measure "Renewals"[ListCustomers1]: A table of multiple values was supplied where a single value was expected.Thanks for your help =]
Hi Anonymous
You are trying to squeeze that code into a measure, which does not allow multiple values.
The code generates a one-column table, as I said. Use the "New Table" button under "Modelling" to create a new table and then add the code to define it. You'll see a one-column table with the list of names.
You can then place a table visual (or matrix) in your report and place 'Acount ID' in rows. 'Acount ID' is the only column in the generated table, ListCustomers1.
Does that help?
Anonymous
cool. glad to hear. how about some kudos then? :smileywink:
Hi Anonymous
You are trying to squeeze that code into a measure, which does not allow multiple values.
The code generates a one-column table, as I said. Use the "New Table" button under "Modelling" to create a new table and then add the code to define it. You'll see a one-column table with the list of names.
You can then place a table visual (or matrix) in your report and place 'Acount ID' in rows. 'Acount ID' is the only column in the generated table, ListCustomers1.
Does that help?
Hi AlB,
I'm out of the office now, but yeah that makes sense. My colleague and I were trawling through all of the online documentation with no success. I'll put it down to it being Friday. =]
Thank you so much for your help.