Last 10 calls

[PBI_Q]

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

[v-easonf-msft · Accepted solution]

Hi, @PBI_Q 

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

[amitchandak]

@PBI_Q , 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