Forum Discussion
Last 10 calls
Hi All,
I am woring on a Report to analyze calls and their details.. where we have calls shown hourly, daily and monthly basis..
I have a requirement, where I need to create reports for last 10 - 10 calls in a periodical manner..
I am looking for a DAX query for that and would appreciate help on that..
Thanks
Hi, Anonymous
You can sort the data based on the date/time column and add an Index column in PQ.
Then you can try to get the result table using the function TopN.
Result Table = TOPN(10,'Table',[Index Column],DESC)Best Regards,
Community Support Team _ Eason
2 Replies
- amitchandak
Super User
Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.Column Rank can help For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns - v-easonf-msft
Community Support
Hi, Anonymous
You can sort the data based on the date/time column and add an Index column in PQ.
Then you can try to get the result table using the function TopN.
Result Table = TOPN(10,'Table',[Index Column],DESC)Best Regards,
Community Support Team _ Eason
