Forum Discussion
churn
Hi Guys, Thanks for your continued support. I have encountered a problem idendifying customers who have bought our subscriptions in one year but not another. Below is a low level example...
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:
