Forum Discussion
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
Anonymous
Did you try Max(End_Date)?
4 Replies
- VasTgMemorable 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
- AnonymousNot applicable
Hi,
Yes there is 1 to many link
between the workorder table and the table showing the end date.
- VasTgMemorable Member
Anonymous
Did you try Max(End_Date)?