Fabric, PowerBI, SQL, ML Blog – Formulas, Ideas, Coffee and more …
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…
Description To calculate the address of a cell in an worksheet. You can use this function to refer cells in other worksheets as well. Syntax ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) row_num: specifies the row number col_num: specifies the column number [abs_num]: optional, which row or column to be fixed (absolute) with $ or relative [a1]:…
Description To calculate the hyperbolic arctangent of a hyperbolic cotangent(number). The Hyperbolic Arctangent is an inverse of a hyperbolic cotangent is a number greater or equal to 1. Syntax ACOTH(number) Examples The results are as follows: References How to calculate Arctangent or ACOT(). If you want to see details what Hyperbolic Tangent is, check here.
Description To calculate the inverse of a Cotangent or Arctangent. The result is in radians number from 0 to pi (3.14) Syntax ACOT(number) Examples The results are as follows: The DEGREES() function is the same as 180/PI(), which basically tells us Arctangent in Degrees References Similar function ACOS calculates Arccosine or inverse cosine.
Description To calculate the hyperbolic arccosine of a hyperbolic cosine (number). The Hyperbolic Arccosine is an inverse of a hyperbolic cosine is a number greater or equal to 1. Syntax ACOSH(number) Examples The results are as follows: References How to calculate Arccosine.
Description To calculate the arccosine of a cosine (number). The Arccosine is an inverse of a cosine ranging from 0 to pi (3.14). Syntax ACOS(number) Examples The results are as follows: The DEGREES() function is the same as 180/PI(), which basically tells us Arccosine in Degrees References Want to see ACOS() in action? Check out…