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 

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?