Forum Discussion
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 ...
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)
)
So, I cannot create a dynamic date series to calculate other measures based on these dynamic dates?
Hi, JoergSch
I'm afraid currently PowerBI doesn't support creating dynamically calculated calendar tables.
Best Regards,
Community Support Team _ Eason