Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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): 3
Thank you
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
10 | |
3 | |
3 | |
2 | |
2 |