locked
MDX Filter to group dates into months RRS feed

  • Question

  • I am having an issue and hoping some folks can help.  I have a Performance Point Dashboard that I want to use an MDX Filter to filter the data based on Months.  My issue is this. I am using as an example the expression below in my filter and get the results that show below it. How can I write my filter to group all these dates together.  For my dates I do not have a full calendar so I can not choose Month, etc.  Any help would be greatly appreciated. 

    The purpose of this is to allow users to choose multiple months.  You can see the dashboard below currently works with the current filter (pardon the date differences, I was using December dates.

    LastPeriods(30,
    [IncidentDim].[CreatedDate].[2012-11-30])

    Friday, December 28, 2012 3:37 PM

All replies

  • In this case your Incident dimension is also a fact table and you should key the created date column into your date dimension so that you can slice and dice.  Once you have this setup you can then setup your date filter based on your date dimension and setup your Month or Calendar based filter.


    Dan English's BI Blog

    Monday, December 31, 2012 12:25 PM