Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display Data in visual Table with duplicate conditions

Hi, 

I am trying to visualise data in in the visual table in Power BI.

 

Here is the data exported into Excel 

End Time column is from another table which is linked the work orders table which supply the first three columns. Adding the last column causes the first few columns to duplicate. 

I am wondering if it possible through DAX or any other means if I could show the work orders by the lastest End Time in the table

like this for example so

 

 

To show the latest bookings for each work order ID

 

Thanks for the responses

 

 

  • VasTg's avatar
    VasTg
    6 years ago

    Anonymous 

     

    Did you try Max(End_Date)?

4 Replies

  • VasTg's avatar
    VasTg
    Memorable Member

    Anonymous 

     

    Do you have relationship defined between the tables? If so, by which colum?

     

    Did you try Max(End Time)?

     

    If it helps, mark it as a solutuion

    Kudos are nice too

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

      Yes there is 1 to many link 

      between the workorder table and the table showing the end date. 

      • VasTg's avatar
        VasTg
        Memorable Member

        Anonymous 

         

        Did you try Max(End_Date)?