DAX

[Anonymous]

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 )

[v-yuta-msft]

Hi Elterrible67,

The formula works well on my side. Click create a table then input the formula.

Sample data:

 

Output table:

 

Regards,

Jimmy Tao

[Greg_Deckler]

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

[Anonymous · Accepted solution]

Hi,

Its p[rovbably an error with my dataset.

Many thanks