When there is a need to provide different values to a calculation, the What-If parameter won't work, and we need an alternate approach.

Last week I launched my blog with an illustration in how to Combine Multiple Excel Files in SharePoint using Power BI. One of the...

A new spin on Power Query's One-click Combine, making your file consolidations more resilient & portable.