Generate Date table dynamically based on What-If parameter

[JoergSch]

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 

[JoergSch]

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

[v-easonf-msft]

Hi, @JoergSch 

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

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

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