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.
Hi experts,
Is there a way to filter a table in Power Query so it only contains data with rows that include a date less than or equal to the date of last refresh?
Thanks!
Solved! Go to Solution.
maybe you need to create a table with one row Date.From(DateTime.LocalNow())
then you need to refer to this line and update the first time.
and if there is no re-update then it will show your first update date
Thanks so much - so everytime i refresh the data the refDate will update to the date of refresh?
Yes exactly!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
84 | |
68 | |
63 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |