Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Can I do a get data from excel that only brings the rows against the most recent date?
Regards
Ross
@rosscortb ,
You can filter table based on date - choose today filter.
It will return only rows matching 9/24/2020 in this case.
Yep. In Power Query, make a custom column that looks like this:
Date.From(List.Max(nameofpreviousstepinquery[yourdatefield]))
That should populate all your data with the most recent date - you can compare your new field and see if it matches with the original date field, and then filter out where it doesn't
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |