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!
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |