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 file. How to use Cube functions In my experience, when using Cube functions, I prefer… Read More »Excel Cube functions explained: Cubevalue, Cubeset, Cubemember
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 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.