Forum Discussion

JoergSch's avatar
JoergSch
Frequent Visitor
4 years ago
Solved

Generate Date table dynamically based on What-If parameter

Hi,

 

I am trying to generate a date table dynamical based on a provided interval and history which I select via a What-If-Parameter.

 

What-If-Parameter "Threshold History" provides the history in minutes from 1 to 120.

What-If-Parameter "Threshold Interval" provides the interval for the date series in minutes from 1 to 30.

 

The date table is calculated as following:

 

DateTimeTable = GENERATESERIES (
MAXX ( ALL('Log'),'Log'[CreatedOn] ) - TIME(0,'Threshold History'[Threshold History Value],0) ,
MAXX ( ALL('Log'),'Log'[CreatedOn] ) ,
TIME ( 0,'Threshold Interval'[Threshold Interval Value], 0)
)
 
The output is 
 
My problem is that e.g. the Interval is not changing when I change the What-If-Parameter "Threshold Interval".
 
How can I achieve that the user could dynamically select the Interval (or the History start)?
 
Many thanks
 
Joerg 
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    JoergSch , You can not use slicer value in a calculated table.

     

    Such tables can be created only as var table in a measure

     

    meausre =

    var _tab  = GENERATESERIES (
    MAXX ( ALL('Log'),'Log'[CreatedOn] ) - TIME(0,'Threshold History'[Threshold History Value],0) ,
    MAXX ( ALL('Log'),'Log'[CreatedOn] ) ,
    TIME ( 0,'Threshold Interval'[Threshold Interval Value], 0)
    )

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    JoergSch , You can not use slicer value in a calculated table.

     

    Such tables can be created only as var table in a measure

     

    meausre =

    var _tab  = GENERATESERIES (
    MAXX ( ALL('Log'),'Log'[CreatedOn] ) - TIME(0,'Threshold History'[Threshold History Value],0) ,
    MAXX ( ALL('Log'),'Log'[CreatedOn] ) ,
    TIME ( 0,'Threshold Interval'[Threshold Interval Value], 0)
    )

  • JoergSch's avatar
    JoergSch
    Frequent Visitor
    4 years ago

    So, I cannot create a dynamic date series to calculate other measures based on these dynamic dates? 

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      4 years ago

      Hi, JoergSch 

      I'm afraid currently PowerBI doesn't support creating dynamically calculated calendar tables.

      Best Regards,
      Community Support Team _ Eason