Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, I was hoping anyone could help me with this problem. See this 3x3 dataset in Query Editor:
When I want to create a table out of this in the report view, I would like to show only the row with the most recent date.
So, ideally, it would say:
However, when I select 'most recent date' under values in report view, it still shows all three rows, like this:
If I select to only show 'Last letter', it shows the c, not the a (probably because of alphabetical order):
How do I change this? I want the 'last letter' do display a, because that's the letter that belongs to the most recent date, not c.
Hopefully I've explained myself well! If not, please let me know.
Lex
Solved! Go to Solution.
@Anonymous
You can add a column to your table to flag the latest record per id as follows:
Flag =
IF(
T14[date] =
MAXX(
FILTER(T14, T14[id] = EARLIER(T14[id])),
T14[date]
),
1,
0
)
Then, assign to the visual filter and set equal to 1
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You can use the TOPN option and assign one on the Filter Pane for Visual Filter
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy, thank you for your help. This seems to work for a single unique ID, but what if the table is to be expanded like this:
And you want to show the most recent date per id with the corresponding letter? It would show like this:
@Anonymous
You can add a column to your table to flag the latest record per id as follows:
Flag =
IF(
T14[date] =
MAXX(
FILTER(T14, T14[id] = EARLIER(T14[id])),
T14[date]
),
1,
0
)
Then, assign to the visual filter and set equal to 1
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This worked! Thank you kind sir.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |