Wyn - Power BI & Excel 
dlvr.it
Dynamic Change Tracking for LMS Enrolments Using Power Query M
While your Moodle LMS data provides a complete snapshot of daily users, course enrollments, and activity statuses, it obscures the vital story educators, administrators, and analysts really care about: what changes occurred since yesterday?
![Master Your Data in Excel & Power BI
Approximate Match Recipe
Prepare Source table
Set data types
Prepare Lookup table
Rename [Match] column to match Source table
Set data types
Perform the match
Reference the Source table
Go to Home ->Append -> Lookup table
Filter the [Match] column -> Sort Ascending
Filter the [Key] column -> Sort Ascending
Right click the [Return] column -> Fill -> Down
Filter the [Key] column -> uncheck null
For more data patters check out our courses at www.skillwave.training](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:ihdq52obivvf6sq3lnalnwrv/bafkreieevojfuyvipc5vt64xcmsvukne2w2monhf7lphodtmdz7jw5vhym@jpeg)
