Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to create a dynamic date filter that will always take into consideration today's date in order to show only the next/upcoming date for each Item. Please see my table below. The idea is that when I filter on Item = A, and i'm looking at this report today (Nov 11th), it will show me only the row with date = 04-Dec-2021. If I filter on Item = B, it will show blank as all the dates available in the table for this item are in the past. If i filter on Item = C, it will show date = 14-Dec-2021, and so on.
Any help would be appreciated. Thank you.
Item: | Date: |
A | 05-Sep-2021 |
B | 04-Jan-2021 |
C | 14-Dec-2021 |
A | 04-Dec-2021 |
B | 19-Feb-2021 |
C | 15-Dec-2021 |
A | 08-Jan-2022 |
B | 20-Mar-2021 |
C | 07-Feb-2022 |
Solved! Go to Solution.
@tomekm you can use this measure
Measure = CALCULATE(MAX('Table'[Date]),FILTER(VALUES('Table'[Date]),'Table 1'[Date]>=TODAY()))
You can create a calculated column like in the screenshot below. Essentially, creating a column that captures the date if it's upcoming/in the future
Hope this helps! Please give it a thumbs up!
You can create a calculated column like in the screenshot below. Essentially, creating a column that captures the date if it's upcoming/in the future
Hope this helps! Please give it a thumbs up!
@tomekm you can use this measure
Measure = CALCULATE(MAX('Table'[Date]),FILTER(VALUES('Table'[Date]),'Table 1'[Date]>=TODAY()))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |