Written by The CUBEVALUE function in Excel is a powerful tool used to retrieve data from OLAP (Online Analytical Processing) cubes. This function is particularly useful for those who need to perform complex data analysis and create detailed reports. Let’s dive into what makes the CUBEVALUE function so userful and how you can apply it effectively. The function is […]
Do you have an old computer laying around? Or do you need a server for your company? No matter what’s the case, setting up a home server is much easier than you think. In this blog, you will learn the technical specification for a home server and everything else you need to setup. Without further […]
In certain times, you would like to split a higher grain number into lower grain by using some percentage ratios. For example, if you have a budget for Product Brand all up, we want to split further the budget into Product Names based on last year’s sales percentage ratios. You can do this by: Procedure […]
Want to give some magic to your Excel modeling? Then its time to call Galdalf and seriously learn about Excel Cube functions! One of my favorite Excel functions to do business modeling are Cube functions. They act as a more efficient replacement for SUMIFS, GETPIVOTDATA functions that serve to sum aggregated results with various filters […]
You all had this experience at least once. You have to calculate the sum of all numbers to n, so naturally you start counting and counting, starting all over again because you made a mistake and finally using a calculator to get the answer. Well I don’t want to ruin your day but you did […]
Anybody up for coloring Egyptian pyramids with Power BI? Just kidding 🙂 How about creating nice looking triangle arrows for your comparison measures colored dynamically based on the values. My goal is to assign up and down arrows or rectangles next to the year-over-year (yoy) growth percentages, colored green for going up and red for […]
What to do if your PowerBI Excel cube is not refreshing new dimensions? Dont let your Excel spoil your refreshing drinks. Read on to find the answer.
If you are running a VM and have trouble connecting to Azure connection strings in Visual Studio, Excel or other Apps and are getting the error message blocking you then it means that you need to updated Internet Explorer Security Configuration Settings
If you want to measure a distance between any two points, there is an Excel formula that does just that. For that you solely need the coordinates of locations (Latitude, Longitude) and a blank Excel worksheet.
Description Indirect function extracts the value of the referenced cell. Syntax INDIRECT(ref_text, [a1]) ref_text: cell address such as A1 or R1C1 format [a1]: if blank then assumes TRUE(), using standard cell reference. If FALSE() then assumes R1C1 format Examples Below are few examples how to use INDIRECT. Note that cell references have to be written […]