- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dax function to display which relative date filter parameter is used
Hi
I have a table of data regarding each user and their login datetime. In my report, I am showing the no. of logins in a column respective to each user in a table by counting the login datetime. There are four buttons(Today,This week,This month,This year) and four bookmarks which are filtered using the relative date filter from the filter panel. By clicking on the buttons, the respective bookmarked(filtered) tables are displayed.
The no. of login column has a custom tooltip which will display "No of logins for <Today/This week/This month/This year>" according to each bookmark page.
Here I need a dax function which will show the above message.
I tried my best and searched for an answer but couldn't find a dax formula to display the relative date filter parameter(day,week,month,year)
Sample table
Name | Status | No of Logins | Role | |
Tom | active | 20 | user | test@test.com |
Bob | inactive | 13 | admin | test1@test.com |
John | active | 25 | user | test2@test.com |
Andy | active | 8 | user | test3@test.com |
Phil | active | 35 | sub admin | test4@test.com |
Expected answer
If the report is on Today bookmark page: No of logins for Today
If the report is on This week bookmark page: No of logins for This week
If the report is on This Month bookmark page: No of logins for This Month
If the report is on This year bookmark page: No of logins for This year
Please ask for any additional information on this.
URGENT HELP NEEDED.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
llo
I think this video could help you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your are welcome...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The video helped me get to my solution..Thank you for that.
I did some modification in my report where I inserted a column with these four words and added a slicer with that column. In each bookmark the respective words are selected and updated the bookmark. Then I hid the slicer from my report. Now with the "selectedvalue" dax function, the desired output is acheived.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
06-19-2019 10:02 AM | |||
06-05-2024 01:31 PM | |||
12-27-2023 01:25 AM | |||
02-06-2024 11:19 AM | |||
03-26-2024 08:52 AM |
User | Count |
---|---|
95 | |
71 | |
44 | |
38 | |
29 |
User | Count |
---|---|
156 | |
92 | |
61 | |
44 | |
42 |