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
How to Create a Calculate Column for The Same Day of Last Year
You can create a calculated column in Calendar Dimension: SameDayLY= var TodayDate = TODAY() var LastYear = YEAR(TodayDate)-1 var LastMonth = MONTH(TodayDate) var LastDay = DAY(TodayDate) return ‘Calendar'[Date]= DATE(LastYear,LastMonth,LastDay) This solution shoule be good for most of the situation. However, your way returned a true value for “2019-03-01” if Today date was a Leap day Read More
Watch Out Google Group “Moderation”, It May Holds Your Group Emails Without Notifications.
Google Group owners are able to moderate the messages sent to their members to protect them from junk mail. Moderation is not active by default and should be set up as appropriate by the group owner. Owners and managers are generally granted permission to determine which messages should be allowed to be sent to group Read More
How To Set Tab Order In Power BI Desktop
What is Tab Order? Tab order is the order in which users interact with the items on a page using the keyboard. Generally, we want tab order to be predictable and to closely match the visual order on the page (unless there is a good reason to deviate). If you press the tab key in Read More