If you are finding a solution for Excel, please read this post. https://summalai.com/?p=3964 Below by Stephanie Bruno One of the unsung heroes to me in Power BI desktop (or Power Query in Excel) is how wonderfully simple it is to combine csv or Excel files from a folder. Maybe it’s not totally unsung, but I Read More
Month: January 2022
How to Fix “A function ‘CALCULATE’ has been used in a True/False expression that is used as a table filter expression. This is not allowed.”
Sample problem: I’m looking for a more elegant way sum based on a prior business day calculation. The following *does work* but will get a little more cumbersome when doing MTD or YTD calculations: Prior Day Invoiced = CALCULATE(sum(‘Sales Ledger Transactions'[Net Sales]),’Sales Ledger Transactions'[Fact Attributes.Source Sale Type Code] = “INVOICED”,‘Sales Ledger Transactions'[Date.Date] = (if(weekday(today(),1)=1,today() – Read More
How to Create Forward Forecasts
In this blog, we’re going to go over how you can create automated forecasts from historic data in Power BI. This is common in businesses to make forecasts and budgets. You may watch the full video of this tutorial. Now, have you ever wanted to create automatic forecasts based on historical information? In the past, this was relatively difficult to Read More
Import Data From a Folder with Multiple Files (Excel)
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of rows and values differ Read More
SSAS, SSIS, and SSRS
What are SSAS, SSIS, and SSRS? Microsoft SQL Server provides many tools to manage and utilize your data. SSAS is Microsoft SQL Server’s Analysis Services which is an online analytical processing (OLAP), data mining and reporting tool used in Business Intelligence to make your data work for you. SSIS stands for Sql Server Integration Services. The key Read More
Power BI vs Tableau vs Amazon QuickSight – Which is Best for Your Organization?
By: Ken Adams This is a common question we get asked as full-service business intelligence professionals. Sometimes the asking organization already owns licenses or is looking to invest in a new tool. Or sometimes the company’s research and analytics departments use Tableau while their financial analysts make use of Power BI. Just about every time, the business Read More