Saturday, April 21, 2012 4:46 PM
Prompt please how to filter a column ' Date ' for example from 01.02.2011 till .
Example of a file
Monday, April 23, 2012 9:42 AMModerator
Tuesday, April 24, 2012 7:31 AMGood afternoon, Challen Fu thanks for the answer. But I have no access to write inquiries to a database.
I would like to understand, whether it is possible in PowerPivot to do column group with dates (on months, quarters, weeks, years) as it is possible to do it in Excel2010? I apologize for my bad English.
Thursday, April 26, 2012 2:41 AM
Unfortunately filtering date range is not supported (yet) in PowerPivot.
As a workaround, you can
1) create an integer calculated column that converts your date value to int value (eg. '01/02/2011' to '20110102'), then you can filter on this column; or,
2) create a measure (eg. myDate) and make it like (=CALCULATE(SUM([MyColumn]), DATESBETWEEN([DATES], "start date", "end date")). Then use this measure as the slicer - but you have to update it everytime you want a different value.
I'd recommend using the first option if I were you.
-- This posting is provided "AS IS" with no warranties, and confers no rights
- Marked As Answer by Egoriy Thursday, April 26, 2012 11:13 AM
Thursday, April 26, 2012 11:13 AMChu Xu many thanks for the answer!