Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys
I have the following table
Company | Category | Value | Date |
Test GmbH | A | This is a Test | 2022-04 |
Test GmbH | A | This is also a Test | 2022-03 |
Test GmbH | B | Hello ABC | 2022-02 |
ABC GmbH | A | This is a Test | 2022-04 |
I have created a parameter which selects the company.
Now I want to display only the latest value in a Category. Like here:
Paramter Company: Test GmbH and Filter for Category A
Company | Category | Value | Date |
Test GmbH | A | This is a Test | 2022-04 |
Currently i am reciving this table:
Company | Category | Value | Date |
Test GmbH | A | This is a Test | 2022-04 |
Test GmbH | A | This is also a Test | 2022-03 |
When I want to filter the latest date with Last(Date), the software tells me I can't use aggregation functions as filter. How can I get the latest date and use it as a filter parameter?
Greetings
Solved! Go to Solution.
Hi guys
thank you for your support.
I was just able to solve it myself by using a matrix instead of a table and the aggregation function Last.
Greetings
Hi @DerMoe ,
In Power Query, after you use Paramter Company: Test GmbH and Filter for Category A, in the date column, there is a Date Filters option, select Is Latest.
Get the expected result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this posthelps, then please considerAccept it as the solutionto help the other members find it more quickly.
Hi guys
thank you for your support.
I was just able to solve it myself by using a matrix instead of a table and the aggregation function Last.
Greetings
Hi guys
thanks for the answers and sorry for the late reply.
Unfortunately I work with Power BI Report Builder and not with Desktop.
Would anyone have a solution for the Report Builder?
Greetings
You can try the function LASTNONBLANK. I see that you value is a text.
Measure =
LASTNONBLANK (TableName[Value], 0 )
.