Forum Discussion

STS_Joshua's avatar
STS_Joshua
Icon for Helper II rankHelper II
7 years ago

Customer 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

    • STS_Joshua's avatar
      STS_Joshua
      Icon for Helper II rankHelper 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.