Forum Discussion
Date Slicer
- 5 years ago
Hello @md264092 , is Table 2 your expected result? If so, you can follow the steps below for the reference.
First, add a new Date column to Table 1.
Date = Tbl1[timestamp]. [Date]Next, create the following measures:
Max_date = MAX(Tbl1[Date]) Min_date = MIN(Tbl1[Date]) TotalLogin = COUNT(Tbl1[ID])Finally, place the Date column in a slicer, place IDs, and three previous measures in a table visual. Now, when you change the maximum and minimum date in the slicer, the data in the table will change accordingly.
Best regards
Community Support Team _ Jing Zhang
If this post helps,please consider Accepting it as the solution to help other members find it.
Hello @md264092 , is Table 2 your expected result? If so, you can follow the steps below for the reference.
First, add a new Date column to Table 1.
Date = Tbl1[timestamp]. [Date]
Next, create the following measures:
Max_date = MAX(Tbl1[Date])
Min_date = MIN(Tbl1[Date])
TotalLogin = COUNT(Tbl1[ID])
Finally, place the Date column in a slicer, place IDs, and three previous measures in a table visual. Now, when you change the maximum and minimum date in the slicer, the data in the table will change accordingly.
Best regards
Community Support Team _ Jing Zhang
If this post helps,please consider Accepting it as the solution to help other members find it.
- Anonymous5 years agoNot applicable
Thank you Jing Zhang for your help.
It worked well!