The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
I have a few visuals where I am using a date Axis and a bunch of measures. I would like to filter out the most recent date, however I'm not sure how to do it.
I have tried this measure but it just returns the second-most recent date.
CALCULATE(data[week_date],FILTER(data,data[week_date]<>MAX(data[week_date])))
Any help would be appreciated.
Solved! Go to Solution.
The solution was simpler than I thought.
Column = IF(data[week_date]<MAX(data[week_date]),data[week_date],BLANK())
The solution was simpler than I thought.
Column = IF(data[week_date]<MAX(data[week_date]),data[week_date],BLANK())
I also saw this post, which deals with a similar problem but I would like my solution to be applicable to multiple measures at once.
https://community.powerbi.com/t5/Desktop/Last-month-data-filter-in-DAX/m-p/210850#M93071
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |