Join table based on the last hit in Power BI

[tiagorolimp]

I am using Power BI and need to join two tables, but I want to display only the last result. Below I show more details:

Table1:

number  description
263745  Bank reconciliation

Table2:

number  status
263745  progress
263745  completed

After joining the tables, the result:

number  description         status
263745  Bank reconciliation progress
263745  Bank reconciliation completed

But I would like to show only the last result, as below:

number  description         status
263745  Bank reconciliation completed

What am I doing wrong?

[v-evelk]

Hello,

It's unclear on when step you want to see this data.

Should dataset be with the only latest record or you want that your visual shows the latest record despite dataset contains all the records?

If you want to build such dataset, it would be better to ask in the appropriate thread.

However, if your question is regarding a visual so, please clarify the target visual.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com