AI, Fabric, PowerBI, SQL, ML Blog – Formulas, Ideas, Coffee and more …
If you listen to Microsoft’s Satya Nadella, OpenAI’s Sam Altman, Google’s Sundar Pinchai or any other Tech CEOs you would probably hear the term “AI” used as a sort of mantra that starts and ends every sentence and sometimes in between. Besides these big guys, everybody else is also talking about AI nowadays, but few…
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…
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…
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.
The AND function in Microsoft Excel is a fundamental logical function designed to test multiple conditions and return TRUE only if all conditions are met. What is the AND Function? The AND function returns TRUE if all the conditions in a test are TRUE, and FALSE if any of the conditions are FALSE. This function…
The AVERAGEIFS function in Microsoft Excel is a versatile statistical function designed to calculate the average of cells that meet multiple specified conditions. Its the older brother of AVERAGEIF and a cousin of SUMIFS and COUNTIFS. What is the AVERAGEIFS Function? The AVERAGEIFS function returns the arithmetic mean of all cells in a range that…
The AVERAGEIF function in Microsoft Excel is a versatile statistical function designed to calculate the average of cells that meet a specified condition. It is a first degree cousin of SUMIF and COUNTIF Excel functions, with the only difference is that it averages the values. What is the AVERAGEIF Function? The AVERAGEIF function returns the…
The AVERAGE function in Microsoft Excel is one of the most commonly used statistical functions, designed to calculate the mean of a set of numbers. What is the AVERAGE Function? The AVERAGE function returns the arithmetic mean of a set of numbers. It is a straightforward yet powerful tool for summarizing data, making it easier…
Ever wanted to write AVERAGE() function in Excel and accidentally hit tab too soon to get AVEDEV? No worries, such function also exists. The AVEDEV function in Microsoft Excel is a statistical function designed to calculate the average of the absolute deviations of data points from their mean. This function is particularly useful for professionals…
One super useful function when you are working with bunch of text and want to convert it into a long array string is by using ARRAYTOTEXT() function. What is the ARRAYTOTEXT Function? The ARRAYTOTEXT function returns an array of text values from any specified range. It passes text values unchanged and converts non-text values to…
The ARABIC and ROMAN functions in Microsoft Excel are powerful tools designed to convert between Roman and Arabic numerals. These functions are particularly useful for professionals dealing with historical data, legal documents, or business reports that utilize Roman numerals. What are the ARABIC and ROMAN Functions? The ARABIC function converts a Roman numeral to an…
The AMORDEGRC function in Microsoft Excel is a financial function designed to calculate the depreciation of an asset for each accounting period using a depreciation coefficient. Unlike the AMORLINC function, AMORDEGRC applies a depreciation coefficient based on the life of the asset. This function is particularly tailored for the French accounting system, where it is…
The AMORLINC function in Microsoft Excel is a specialized financial function designed to calculate the linear depreciation of an asset for each accounting period. It is similar to AMORDEGRC function, but is linearly calculated, while the later is calculated using depreciation coefficient based on the life of the asset. This function is particularly tailored for…