Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Solved! Go to 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)
)
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
@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)
)
User | Count |
---|---|
83 | |
78 | |
62 | |
61 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |