Forum Discussion
Latest telephone call
Hi, I have a telephone call data table with numerous fields including: CallDateAndTime CallFrom CallTo TelNo I have been using this table in Power BI for over 12 months and the information...
As long as your dates are sorted so that the most recent is as the top, simply removing duplicates will give you the desired output.
Thanks Nick, I did think of that but Power BI doesn't support the remove duplicates functionality with DirectQuery & it would change to Import which wouldn't work for us as it's a dashboard/report fed by a SQL table and is updated automatically throughout the day.