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 applied. Cube functions (CUBEVALUE, CUBEMEMBER, CUBESET) will only work if you have a PowerPivot model or live cube connection in your Excel…
Setting up a Wireguard VPN (on Linux)
A VPN (virtual-private-network) allows you to route all your traffic through a computer. This makes your browsing more secure and you can bypass regional-blocked content. Modern-day options include NordVPN, ExpressVPN, etc. but today I am going to show you why and how to create your own VPN using Wireguard. Why? Have you ever heard VPNs…
Sum of all numbers from 1 to n
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…
Are vector-databases the new craze?
Unlike traditional databases that use a row-column-architecture, vector-databases use vectors to represent their data. For reference a vector is a 1-dimensional array of numbers like [0.64, 0.32, 0.97]. This means that there isn’t a set grid where the vectors can be placed while still being able to do classical operations. All these vectors get stored…
Power BI: add KPI arrow triangles to your Variance Metrics
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…
Analyze in Excel PowerBI Cube not refreshing new dimensions after publish
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.
Fix Blocking Errors when Connecting VM to Azure due to Internet Explorer Security Settings
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
Excel – measure distance between any points on Earth
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.
Excel CUBEVALUE vs SUMIFS & GETPIVOTDATA
Once CUBEVALUE formula came out about 10 years ago along with PowerPivot, I was delighted because it had filled the gap that was missing in SUMIFS and GETPIVOTDATA formulas for certain usage scenario.
Formatting Calculated Items of Calculated Groups in Tabular Editor
In the previous post I explained how to create Calculated Groups (Calculated Groups – comparisons and calculated columns in a pivot directed by slicers » Data Empower), here I will talk about how to create different formatting for the calculated items. For those of you created Calculated Groups in PowerBI using Tabular Editor (Tabular Editor),…