Last X values

[Anonymous]

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:

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

[amitchandak · Accepted solution]

@Anonymous , last 10 means the last 10 dates or transactions.

You can use Rank

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[tex628]

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

[Anonymous]

@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.

[Greg_Deckler]

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.