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
Anonymous
Not applicable

Last X values

Hello

 

Is it possible to filter a visual so that it shows the last X values, where X could be 10 as an example?

 

Lets say I have the following visual:

Capture.PNG

It currently shows the last 30 days, but I would like for it to show the last 10 observations instead.

How can I do this?

 

Thanks

1 ACCEPTED SOLUTION
4 REPLIES 4
tex628
Community Champion
Community Champion

To do that you will need to create a calculated column to rank the observations in order of most recent. What exactly is an observation in your scenario? 

/ J


Connect on LinkedIn
Anonymous
Not applicable

@tex628 

 

I am running a robot.

The robot performs a transaction. The time it does this is saved as "transactionStart" and is in the date and time format: 16-04-2020 08:09:30.

Once done, the transaction gets a status depending on the outcome of the run. This can either be "Successful", "App. Exception" or "Bus. Exception" as shown in the previous picture.

 

Try something like like.

 

1^(1/(MAX('Table'[TransactionStart]) - [TransactionStart]) * 1.)

 

Your top 10 numbers (TOPN filter) are the the ones to display.

 

Or, don't bother with a new column at all, just use TOPN filter on your TransactionStart column or a column with formula [TransactionStart] * 1.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.