21 April 2012 16:46
Prompt please how to filter a column ' Date ' for example from 01.02.2011 till .
Example of a file
23 April 2012 9:42Moderator
24 April 2012 7:31Good 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.
26 April 2012 2:41
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
- Ditandai sebagai Jawaban oleh Egoriy 26 April 2012 11:13
26 April 2012 11:13Chu Xu many thanks for the answer!