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

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