The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 )
.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
78 | |
36 | |
35 | |
23 | |
16 |