VBA If Statement Ref: https://www.automateexcel.com/vba/else-if-statement
Category: Microsoft Family
Microsoft Windows Servers, AD, Exchange, Azure, Windows 10, Office 365 and more
How to Do a Forecasting in Power BI
We now see a line graph like the one below. Head over the Visualization panel and under the list of icons, find the analytics icon as shown below. Scroll down the panel and find the “Forecast” section. Click on the down arrow to expand it if necessary. Next, click on “+Add” to add forecasting on Read More
How To Add A Button Using Bookmarks In Power BI
In this article, you will learn how to create a button and how to use it in Power BI reports. In a Power BI report, you can add different types of buttons, as shown in the below image. In this article, I will create a button using a bookmark. A bookmark is a very useful Read More
How to Add a Column with Fiscal Month or Fiscal Week Number Not Starting From Jan 1?
Part I – Fiscal Month Here is a potential solution assuming you have some kind of data table with a column called Value that has your dates in it: Create a “Standard Month” column using MONTH([Value]) For example, create a “Custom Month” column for the Fiscal month starting from April 1: Part II – Fiscal Read More
How to Optimize Performance in Power Query
Occasionally, organizations will need to address performance issues when running reports. Power BI provides the Performance Analyzer tool to help fix problems and streamline the process. Consider the scenario where you are building reports for the Sales team in your organization. You’ve imported your data, which is in several tables within the Sales team’s SQL Read More
How To Convert UTC to Local DateTime in Power BI
Solutions 1: Convert Time Zones – FORMAT Even if your SharePoint site’s regional settings are correct (or whichever data source you’re pulling from), Power BI could convert it to the wrong time zone upon import. It’s a quick fix, luckily. Instead of using your “modified,” “created” or other date fields in your report, we’ll create Read More