Forum Discussion

tiagorolimp's avatar
tiagorolimp
New Member
6 years ago

Join table based on the last hit in Power BI

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?

1 Reply

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    6 years ago

    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
    [email protected]