How to VLOOKUP Multiple Matching Rows Using Power Query? VLOOKUPS (and XLOOKUPS!) are a great function in Excel but they cannot be used to find multiple matching rows in a Lookup table. VLOOKUPS only return the first matching row that…
How to Connect Power Query in Power BI or Excel to a Sharepoint file. Being able to connect Power BI or Power Query in Excel to files on Sharepoint is a really useful skill. While connecting to files on OneDrive…
The easiest way to dynamically identify dates that are in the following month in Power Query is to use the function Date.IsInNextMonth. We learn how to use the function in this post.
1 BIG reason to use the Sharepoint Folder connection in Power BI What’s the main advantage to using the Sharepoint Folder connector in Power BI? BUSINESS CONTINUITY. The ability for essential reporting to carry on in a business while key…
You must be logged in to post a comment.