Select latest Date and use it as a filter

[DerMoe]

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

[v-yanjiang-msft]

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.   

[DerMoe · Accepted 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

[DerMoe]

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

[Tutu_in_YYC]

You can try the function LASTNONBLANK. I see that you value is a text.

Measure = 
LASTNONBLANK (TableName[Value], 0 )

.