Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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 

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi Anonymous 

use the automatic created measure not the table column!

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi FrankAT ,

 

I belive that is what I'm trying to do:

 

 

 

 

 

 

The calculator indicates that it is the measure, right?

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi Anonymous 

    see figure:

     

     

    Use the measure (in this example) Multiply by Value in your DAX formula as the multiplier.

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      FrankAT  Thanks!

       

      My formula now looks like this: 

      FutureAUM = CALENDAR(LASTDATE(Holdings[AsOfDate]),LASTDATE(Holdings[AsOfDate])+(365* SELECTEDVALUE('nYears'[nYears],3))
       
      So, the problem now is that it uses 3 years, becuase of the [AlternateResult] = 3, and it does not change if I change the input in the parameter... Any clues?