Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello community, is it possible that through a DAX function I can show a selected date of a TIMELINE? For example, I want to get the minimum date of the year that I have selected in the image.
Thanks for your support!
Hi @DanCasSan ,
You can use the 'Timeline 2.1.1' visual to select a timeline and create the following measure to get the start date and end date:
Start Date =
CALCULATE ( MIN ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
End Date =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
The following result may be your expected:
Here is the same issue that you can also refer: Get start and end date from Timeline Slicer
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
This worked for me wonderfully. Thank you! 😎
Well, let's say that you are using Date column from Calendar table, then you would do this:
Minimum Measure = MIN('Calendar'[Date])
Yes. But if I put the minimum, I will get the minimum date of the entire table, for this example the date would be 01/01/2016, and what I need is the date 01/01/2018 (the year that is being selected).
Hi,
As long as you drag Date from the Calendar Table to the slicer, Greg's suggestion should definitely work.
@DanCasSan , Somehow I see Day timeline 2.1.1
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |