How to calculate the Sales for a specific day for all years in PowerPviot?

[CopperKnife]

Hi,

I have been struggling to calculate the Sales Qty for a specific day/days from all years. I have data for 12 years. Even calculating sales between two days from all years also is one of requirement. What should be DAX formula given the following tables/columns.

1. dimSales with all obvious columns i.e. OrderID, OrderDate, Customer, Product, Qty etc
2. dimDates with Date, Day, Month, Qrt, Year etc
3. dimProducts with Product, Cost, Price etc
4. dimDiscount with columns: DiscStartDate, DiscEndDate, DiscName, DiscPercent.

Now I want to calculate and compare two things on Christmas sales for all years,

1. Sales on those days.
2. Discount allowed on those days.

Please assume the obvious relationships existed between my tables. Any additional information can be provided, if needed.

Thanks a ton for your help!

CopperKnife

 

[scottsen]

I think this works?
Xmas Sales := CALCULATE([Sales], dimDates[Month] = 12, dimDates[Day] = 25)

 

[CopperKnife]

Scottsen,

Thanks for your answer. I would be very glad if you give a formula for the following.

1. How to calculate my sales between two given dates,
2. How to calculate discount allowed between two dates (the discount dates will be in dimDiscount table)?

If an OrderDate from FactSales Table falls between a DiscountStartDate and DiscountEndDate which are from dimDiscount table, then we have to calculate a DiscountPct.

Thanks a ton man.
CopperKnife