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.
I want to get number of days in the month I've chosen from Timeline slicer.
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