Hi,
I have a spreadsheet where I used slicers on the year and month (yyyy-mm) that I referred to in my formulas to show a dynamic title saying "Report from Nov-2015 to Sep-2016" etc.
If there a way to refer to the minimum and maximum values selected in a timeline in a similar fashion?
The code I used to get the minimum selection on the slicer was:
=CUBERANKEDMEMBER(DataModelRef,CUBESET(DataModelRef,Slicer_YearMonth),ROW(D1))
where "DataModelRef" is the connection, and "Slicer_YearMonth" is the slicer name where I selected the month and years to show
The code used to get the maximum selection on the slicer was:
=CUBERANKEDMEMBER(DataModelRef,CUBESET(DataModelRef,Slicer_YearMonth),CUBESETCOUNT(Slicer_YearMonth))
Thanks!
Lisa
I have a spreadsheet where I used slicers on the year and month (yyyy-mm) that I referred to in my formulas to show a dynamic title saying "Report from Nov-2015 to Sep-2016" etc.
If there a way to refer to the minimum and maximum values selected in a timeline in a similar fashion?
The code I used to get the minimum selection on the slicer was:
=CUBERANKEDMEMBER(DataModelRef,CUBESET(DataModelRef,Slicer_YearMonth),ROW(D1))
where "DataModelRef" is the connection, and "Slicer_YearMonth" is the slicer name where I selected the month and years to show
The code used to get the maximum selection on the slicer was:
=CUBERANKEDMEMBER(DataModelRef,CUBESET(DataModelRef,Slicer_YearMonth),CUBESETCOUNT(Slicer_YearMonth))
Thanks!
Lisa