Forum Discussion
STS_Joshua
Helper II
7 years agoCustomer List YTD vs SAMEPERIODLASTYEAR
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!
2 Replies
- Greg_Deckler
Community Champion
See about using EXCEPT
- STS_Joshua
Helper II
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.