Forum Discussion
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:
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
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
4 Replies
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-finaleTo 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?
/ JI 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.
