- 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
feed user's date selections into a measure to calculate value between those dates
I'm a total beginner trying to create a dashboard that allows users to calculate the difference between values associated with two dates. e.g. price of 1 unit in march 2019 and the same unit in december 2018. Those dates would be specified by a filter. How do i reference filter selections in my measures? Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As long as the filter is on the page level, or at least the visual level where the measure will be used, simply using something like this will give you the first date in the filtered date range:
MIN('Date'[Date])
MAX() would give you the max.
Note though that if your filter is on the visual level and not the page level, the same measure could give you different results if used in multiple visuals.
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you . is that if the date is set in the visualizations pane, or with the end user selecting the dates in the dashboard itself?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is if set in the new Filter Pane. How are they setting filters in the dashboard?
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The dashboard would be set up with a table or slicer (whatever can be referenced by DAX) listing the date options. The user would then select the range of dates to compare, for example the value in Q12019 with the value of the same item in Q1 2018. they dont have access to the filter or visualizations or fields panes.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-30-2024 12:15 PM | |||
12-19-2023 10:49 AM | |||
02-23-2024 07:05 AM | |||
06-12-2024 12:02 AM | |||
09-28-2023 06:14 AM |
User | Count |
---|---|
134 | |
105 | |
87 | |
55 | |
46 |