How to reference an excel cell into a Measure's formula - PowerPivot Table - Excel Sheet RRS feed

  • Question

  • Hi there,

    I am working with a PowerPivot excel 2010 sheet. I have some slicers, a powerpivot table.

    I also have the following requirement: The user has to be able to select a date range from two fields (Date From and Date To). These two fields have to be a current excel cells.

    So at this point, I have built a new custom measure with using the DATESBETWEEN function. I have mocked up the Start Date and the End Date of the DATESBETWEEN with two fixed values. It's working OK. But I don't know how to reference the Date From and Date To cells in the DATEBETWEEN on the custom measure's formula.

    Any idea?


    Thanks and best regards,


    Wednesday, June 15, 2011 5:30 PM


All replies