Dax measure for comparable dynamic SUM

[monaldo12]

Hi,

Been fighting with chatgpt whole day but it seems impossible. So I have a dataset with orders. Made a report with a slicer to filter the order dates, this is made dynamic.
I have a measure which works for this dynamic filter to calculate the SUM of orders:
Dynamic measure =
CALCULATE(
SUM(orders[OrderCount]),
DATESBETWEEN(
Orders[orderdatum],
MIN(Orders[orderdatum]),
MAX(Orders[orderdatum])
)
)

I just need another measure to calculate the same stuff, for the same selected period as in the dynamic measure, but want it for 1 year earlier (call it comparable measure).
So when I select jan 2023 till april 2023 the dynamic shows me the sum of this period, the comparable measure needs to show me jan 2022 till april 2022. How to do this?

 

[Matt Allington]

1. Stop using ChatGPT
2. Learn some dax. My book is $14.95
3. get a calendar table https://exceleratorbi.com.au/power-bi-calendar-tables/

Total orders = sum(orders[ordercount])
total orders last year = calculate([total orders],sameperiodlastyear(calendar[date]))

 

[monaldo12]

1. Stop using ChatGPT
2. Learn some dax. My book is $14.95
3. get a calendar table https://exceleratorbi.com.au/power-bi-calendar-tables/

Total orders = sum(orders[ordercount])
total orders last year = calculate([total orders],sameperiodlastyear(calendar[date]))

Not working, so not buying your book