Customer List YTD vs SAMEPERIODLASTYEAR

[STS_Joshua]

Hi all,

I am having trouble creating a way to show a list of customers who have ordered YTD for 2019 vs. the same time period in 2018. My data starts 1/1/2018 and runs to present day. I have a date table for this period as well.

I have created measures to give me a count of distinct customer names for these periods by doing:

customers = DISTINCTCOUNT('Query1'[CardName])

customers19 = CALCULATE(DISTINCTCOUNT('Query1'[CardName]), YEAR('Query1'[DocDate])=2019)

customers_roll12 = CALCULATE('Query1'[customers], SAMEPERIODLASTYEAR('dates'[Date]))

I can then use these measures to give counts of customers who have bought ItemA vs. ItemB in 2019 and then compare this to last year. I want to then be able to list the customers who have bought it in 2019 vs. who bought it in this time period last year.

Thanks in advance!

[Greg_Deckler]

See about using EXCEPT

[STS_Joshua]

How would I go about doing that? EXCEPT appears to be a sort of table join. In my case all of this data is on the same table.