I want to get number of days in the month I've chosen from Timeline slicer.
I want to get number of days in the month I've chosen from Timeline slicer, does anyone know how to do?

The problem I want to solve is to divide the number of customer visits as a salesman made during a month by the number of days in the month.
April 9th, 2015 10:21am

Hi Gran,

this one also works for Standard Pivots: http://www.powerpivotpro.com/2010/12/another-way-to-get-and-use-slicer-values-in-formulas/

Free Windows Admin Tool Kit Click here and download it now
April 10th, 2015 12:50am

Excel 2013 Pro Plus with PowerPivot.
Count working days per month
considering weekends and holidays.
With help from book:
"Building Data Models with PowerPivot"
by Alberto Ferrari and Marco Russo.
Easy. Not.
http://www.mediafire.com/view/rw78t1y3bg8vm0c/04_10_15.xlsx

April 10th, 2015 8:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics