stillground_ca
New Member
- Joined
- Jun 12, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
- Mobile
- Web
Hello,
I have the Dax code below. All works fine except the code after RETURN. I am working with Dax Studio. I want to return list of Customer IDs in 2014 that are not in other years. Kindly help resolve. Thanks
I have the Dax code below. All works fine except the code after RETURN. I am working with Dax Studio. I want to return list of Customer IDs in 2014 that are not in other years. Kindly help resolve. Thanks
Code:
EVALUATE
VAR main_table = SELECTCOLUMNS(Orders,"Order Dates",Orders[Order Date],"Customer IDs",Orders[Customer ID])
VAR table1 = FILTER(table1,Year([Order Dates])=2014)
VAR table2 = FILTER(table1,Year([Order Dates])<>2014)
VAR Distinct_table1 = Distinct(SELECTCOLUMNS(table1,"IDS-1",[Customer IDs]))
VAR Distinct_table2 = Distinct(SELECTCOLUMNS(table2,"IDS-2",[Customer IDs]))
RETURN
Filter(Distinct_table1,[IDS-1] NOT(Distinct_table2))