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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tulsi
Helper I
Helper I

Top 2 tasks by month

Hi,

 

I have to get top 2 tasks by month starting from august 2017-now. When I'm using the top n filter it's giving me common top 2 tasks for all the months. I need top 2 tasks for that particular month.

Data source looks something like this:

datasource

1 ACCEPTED SOLUTION

Hi @tulsi

 

You may try to add a rank measure as below. Then drag it to visual level filter and set the measure is less than or equal to 2. If it is not your case, please share some data sample.

Rank =
RANKX ( ALL ( Table[task name] ), CALCULATE ( SUM ( Table[Qty] ) ) )

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

11 REPLIES 11

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.