Forum Discussion
Use slicer value to multiply
Hi, I use a CALENDAR function to create a calendar from the last date in my table and 365 days into the future, based on this formula: FutureAUM = CALENDAR(LASTDATE(Holdings[AsOfDate]),LASTD...
Hi Anonymous ,
You could use SELECTEDVALUE() function.
Create a table with columns contains values (1,2,3,4,5,...) adn use this column as dropdown slicer.
Modify your formula as below.
FutureAUM = CALENDAR(LASTDATE(Holdings[AsOfDate]),LASTDATE(Holdings[AsOfDate])+365*SELECTEDVALUE('slicer'[slicer]))Best Regards,
Jay
Anonymous , if you are creating a table. I doubt you can use slicer parameters