Fabric, PowerBI, SQL, ML Blog – Formulas, Ideas, Coffee and more …
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…
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…
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…
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.
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.
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),…
I want to show a situation how using Calculation Groups we can create a pivot or matrix in which using 2 different drop downs (slicers), a user would compare different versions of data in the pivot and their variances. For example, if in the slicer 1, you select Brand A and in slicer 2, you…