none
filter a column

תשובות

  • 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

    • סומן כתשובה על-ידי Egoriy יום חמישי 26 אפריל 2012 11:13
    יום חמישי 26 אפריל 2012 02:41

כל התגובות

  • Hello Egoriy,

    It seems that you want to filter the records between two rangs, you can switch to Query Editor by clicking the table properties, then in the query editor you can edit your query at your will.

     


    Challen Fu

    TechNet Community Support

    יום שני 23 אפריל 2012 09:42
    מנחה דיון
  • Good 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.
    יום שלישי 24 אפריל 2012 07:31
  • 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

    • סומן כתשובה על-ידי Egoriy יום חמישי 26 אפריל 2012 11:13
    יום חמישי 26 אפריל 2012 02:41
  • Chu Xu many thanks for the answer!
    • סומן כתשובה על-ידי Egoriy יום חמישי 26 אפריל 2012 11:13
    • סימון כתשובה בוטל על-ידי Egoriy יום חמישי 26 אפריל 2012 11:15
    יום חמישי 26 אפריל 2012 11:13