date intelligent

  1. mrxlsx

    How to calculate sales for same dates every year?

    Hi all, I have the obvious relationships in my power pivot data model. I have 2 tables....Sales and Dates DimDate[DateKey] --> Sales[Orderdate] I want to calculate sales for the following specific dates and slice them by years. Jan-1st to Jan-1st is called NewYearSales, Dec-25th to...
    • mrxlsx
    • Thread
    • calculate date intelligent dimdate[datekey] pongalsales sales
    • Replies: 0
    • Forum: Power Tools
  2. C

    Problem with comparing Previous month/years in DAX

    Hi all, I have a Date table and Fact table. Cols in Date table: Date Month Qtr Year MonthName QtrName YearName Cols in Fact table: Date Product Country Region Qty In DAX, I need to write an expression for calculating the following: (JanPrevYear + FebPrevYear / JanCurrYear+ FebCurrYear)-1...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top