Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We are trying to create a page level filter on the MAX(Date). By default the page level filters do not have the "Latest" filter like when you're creating a card visual. We have tried creating a MEASURE for the "Latest Date" and then creating a Calculated Column where if the DATE = Latest Date then it's true and if not false among many other suggestions from the web. It seems that since we are working in Direct Query mode, many of the suggestions do not work.
Latest Date = MAX([Date])
Is Latest = IF([Date] = [Latest Date], TRUE(), FALSE())
ERROR: Function 'MAX' is not allowed as part of calculated column DAX expressions on DirectQuery models.
Our data looks like the following and with the desired functionality we will only be looking at the BOLDED records.
ID | Date | Miss Pg | Miss Vis | Clean | Locked | Signed |
10 | 3/21/17 0:00 | YES | YES | YES | NO | NO |
9 | 3/21/17 0:00 | NO | NO | YES | NO | NO |
8 | 3/21/17 0:00 | NO | NO | NO | YES | YES |
7 | 3/20/17 0:00 | YES | YES | NO | YES | YES |
6 | 3/20/17 0:00 | YES | YES | NO | NO | NO |
5 | 3/20/17 0:00 | NO | NO | YES | YES | YES |
4 | 3/19/17 0:00 | NO | NO | YES | NO | NO |
3 | 3/19/17 0:00 | YES | YES | YES | YES | YES |
2 | 3/19/17 0:00 | YES | YES | YES | NO | NO |
1 | 3/19/17 0:00 | NO | NO | YES | NO | NO |
Wondering if any of you have found a solution? I'm bummed that I got this to work so well in Import but can't transfer the methodology to Direct Query.
I'm having the same problem, does anybody have a solution?
Latest date is always today's date or latest date is based on the last record in the table, please clarify?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k, actually neither. "Latest" means the most recent date in the date column. It will not always be today and the records may not be in order so it can't be the "last" record. It should be equivalent to MAX() or LATEST() in terms of a datetime.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |