Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PBI_Q
New Member

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

 

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

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
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors