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...
Thanks adityakommu & nickhamilton,
I have put together a screenshot of some fictional numbers/sample data below:
In the above sample, I have included several different numbers - some with multiple calls associated with them.
Ideally I would like my Power BI data/report to show the following:
I hope this helps!
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.