Forum Discussion
Pre set Min/Max date values in custom measures
- 4 years ago
Bokchoy
As my knowledge goes, I don't think it's even possible and frankly, I am not sure about the actual use case.
If you need a table with dynamic value, just create the same Table as Visual and add the new measure as the column and then you have your desired Column, you can then export that table or do other stuff with it.
The Measure you used will most likely work for the desired column.
Hi, Bokchoy ,
if you want the new measure to be dynamically chosen by the two slicers, just use in your new measure following:
var mindate = MIN('Your Table'[YourDate])
var maxdate= MAX('Your Table'[YourDate])and you're simply done.
Hi Vojtechsima,
Sorry, i didn't explain my question clearly. I'm trying to create a custom column, not a measure. I've updated the post
- vojtechsima4 years ago
Super User
Bokchoy
As my knowledge goes, I don't think it's even possible and frankly, I am not sure about the actual use case.
If you need a table with dynamic value, just create the same Table as Visual and add the new measure as the column and then you have your desired Column, you can then export that table or do other stuff with it.
The Measure you used will most likely work for the desired column.