Current and Previous recharge dates

[mvidalbenitez]

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

[v-eachen-msft]

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.

[mvidalbenitez]

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): 3

Thank you

[Greg_Deckler]

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