dax time funtions

  1. A

    Dax function R12M

    Hi, I have written a measure in DAX to calculate the turnover of the past 12 months (Rolling 12 months) per customer: CALCULATE([Turnover]; FILTER(ALL(T_Calendar); T_Calendar[MonthNumber]=MONTH(TODAY())-1&&T_Calendar[Year]=YEAR(TODAY())...
  2. M

    Year end store number should be equal to fourth qurter of the same year.

    I have following table. <tbody> Date Segment Quarter No of stores No of sales 31/12/2017 America Q1 100 45216 31/03/2017 America Q2 200 6589 30/06/2017 America Q3 300 2388 30/09/2017 America Q4 500 6358 </tbody> I want to display year end figures in the pivot table. I have created a...
  3. D

    Date table question

    Hello, I recently started watching the amazing ExcelisFun power pivot videos by Mr. Girvin and have been having a blast learning about all of the capabilities and ease of use. I have two questions about the date table that I really need some help with. I've been searching the internet for a...

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