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 

create a new parmeter on tab Modeling. Power BI Desktop creates a new table with measure to use as multiplier. Insert this measure into your DAX formula.

 

 

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,

 

Thanks for the reply! 

 

Like this? 

FutureAUM = CALENDAR(LASTDATE(Holdings[AsOfDate]),LASTDATE(Holdings[AsOfDate])+(365*nYears[nYears Value]))
 
 
 
I chose the slicer to be 2 in this case. If I do it like that, the graph dissapears. However, if I use 
FutureAUM = CALENDAR(LASTDATE(Holdings[AsOfDate]),LASTDATE(Holdings[AsOfDate])+(365*2)), the graph expands to two years.

 

 

 

  • 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)