Forum Discussion
Current and Previous recharge dates
Hello guys,
How can I get the last two recharge dates (current and previous) on my model?
Or keep a history of recharges?
Thank you
3 Replies
Difficult to say. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Maybe something along the lines of https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814
Hi mvidalbenitez ,
Your could describe your issue more clearly by sharing screenshots or sample data.
According to your situation, you could use RANKX() function and add a filter( earlier than current date ) to show the result.
The report is reloaded every hour into a mysql database, and I need to show the data differences between current and previous reload (RefreshTime).
Is it possible to create the RefreshTime field in the data model with an incremental update to detect hourly changes?
Another option could be to call a stored procedure in SQL Server to store the reload times.
Example:
New tickets (previous reload): 2
New tickets (current recharge): 3Thank you
