Forum Discussion
DAX
Hi guys,
I've the following DAX Expression which is giving me an error . I'm trying to find what customers didn't renew subscription in 2018 that renewed in 2016 and 2017.
Any help would be most appreciated.
ListCustomers1 =
VAR T2016 =
CALCULATETABLE (
VALUES ( Renewals[Account_ID] );
Renewals[Renewal Year] = 2016
)
VAR T2017 =
CALCULATETABLE (
VALUES ( Renewals[Account_ID] );
Renewals[Renewal Year] = 2017
)
VAR T2018 =
CALCULATETABLE (
VALUES ( Renewals[Account_ID]);
Renewals[Renewal Year] = 2018
)
RETURN
EXCEPT ( INTERSECT ( T2016; T2017 ); T2018 )
3 Replies
What is the error? Sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Elterrible67,
The formula works well on my side. Click create a table then input the formula.
Sample data:
Output table:
Regards,
Jimmy Tao
