Forum Discussion
Need Dynamic DAX for DatesInPeriod
Community SupportHi, Anonymous
According to your description, You want to replace your "26" fixed value, generating a dynamic value that can be modified. Right?
The following is a method to replace the value, you can refer to :
(1)We can create a “What if” parameter :
(2)We can enter the interval range and interval of the variable we want:
(3)Then it will automatically generate a slicer and a measure for us:
Parameter Value = SELECTEDVALUE('Parameter'[Parameter])
(4) We can use this measure to replace your “26” fixed value to achieve dynamic through slicer selection value.
If this method cannot help you solve the problem, you can delete your private data and provide your sample data in the form of a table or .pbix file, and describe your detailed needs, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Aniya,
The only issue with this is that I want to plot the entire time series on a column chart using the created_at date as the time column. The slicer will still only give me discrete values depending on what date I want to look at