March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingthank you . is that if the date is set in the visualizations pane, or with the end user selecting the dates in the dashboard itself?
That is if set in the new Filter Pane. How are they setting filters in the dashboard?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
126 | |
85 | |
69 | |
53 | |
44 |
User | Count |
---|---|
202 | |
106 | |
100 | |
64 | |
56 |