What the DAX?

 This is a meta data information function that returns a table containing information about the Delta tables that are being used in a Power BI model and allows troubleshooting. The function returns a table with the following columns:     ID: A unique identifier for the delta table storage.     PartitionStorageID: The ID of the partition storage associated with the delta table.     TableName: The name of the delta table.     RootLocation: The root location of the delta table storage.     CurrentVersion: The current version of the delta table storage format.     TableObjectID: The object ID of the delta table.     DatamartObjectID: The object ID of the datamart associated with the delta table.     FramedSchemaName: The framed schema name of the delta table.     FallbackReason: A code indicating the reason for falling back to a different storage format. Typical Usage:     Understanding ...

 A financial DAX function that returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. Syntax EFFECT (<Nominal_Rate>,<Nr_of_Compounding_Periods_per_year>) https://dax.guide/effect/

 This is a DAX function that returns a table with the missing values from a summarize function. E.g if 5 years of data but sales in only 2 years. Summarizecolumns function would only return 2 row for the years with sales. i.e . misisng the rows that did not have sales.  Using this function inconjuctionn with sumarizecolumns would return 5 rows (one frow for each row) but showing a blank for the years without sales https://dax.guide/addmissingitems/

 DAX function that returns the name of a column or measure Syntax NAMEOF(<value>) https://dax.guide/nameof/

A simple boolean DAX function that converts TRUE to FALSE OR a FALSE in to TRUE Syntax NOT(<Logical>) https://dax.guide/not/

 A Dax function that returns a table with a column with the first non blank value it finds Syntax FIRSTNONBLANK(<ColumnName>, <Expression>) https://dax.guide/firstnonblank/

 This DAX Function shows an alternative value if there is an error in the expression Value that is being passed to the function Syntax IFERROR(<Value>, <ValueifError>) https://dax.guide/iferror/

 This is a time intelligence DAX function that returns a scalar value where the context has been changed to the last day of the current year Syntax CLOSINGBALANCEYEAR(<expression>, <Dates>, <Optional Boolean filter>, <Optional EndofYear Date>) https://dax.guide/closingbalanceyear/

 A DAX function that returns all the dates  (1st Jan to 31st Dec) between the min and  max dates in the data model Syntax CALENDARAUTO(<FiscalYearEndMonth>) An optional parameter between 1 and 12 that takes the end month (instead of 31st December) https://dax.guide/calendarauto/

 Perspective tables are views on the existing Data model that simplify the data for specific use cases. They are created using Tabular Editor The Info.Perspectivetables DAX function returns a table the lists out details about all Perspective tables in the model. This can the be used to dynamically access these columns in other DAX functions. Using the Schema Data Management Views. https://dax.guide/info-perspectivetables/

 This DAX function returns Boolean (True/False) if a value is found in a delimited list Syntax PATHCONTAINS(<Path>,<Value to find>) Where Path is a string of delimited values - delimiter = | https://dax.guide/pathcontains/

This is a financial DAX Function that returns the price per $100 face vale of a security that pays periodic interest Syntax PRICE(<Settlement>, <Maturity Date>, <Coupon Rate>, <Yield>, <Redemption Value>, <Frequency>, <Basis> ) https://dax.guide/price/

 This is a statistical function that returns the number of combinations a number can be chosen from an list of numbers without repitition Syntax COMBIN(<Numers>, <Numbers_Chosen) https://dax.guide/combin/

 This is a statistical DAX function that returns the estimated standard deviation based on a sample. The sample being the values in column ignoring logical values and text. Syntax STDEV.S(<ColumnName>) https://dax.guide/stdev-s/

 One of the core aggregation DAX Functions. COUNT returns the count of non blank rows in a column in a table Syntax COUNT(<ColumnName>) https://dax.guide/count/

 This is an informational DAX function that returns a table showing Relationship details. Uses the TMSSchema_Related_Column_Details Data  Management View Real-world example: Imagine you're working with a sales dataset that has two tables: SalesOrders: Contains information about sales orders, including order ID, customer ID, and order date. Customers: Contains information about customers, including customer ID, customer name, and region. There's a one-to-many relationship between Customers and SalesOrders based on the Customer ID column. Using INFO.RELATEDCOLUMNDETAILS: To get detailed information about this relationship, you can use the following DAX formula: INFO.RELATEDCOLUMNDETAILS(RELATEDTABLE(SalesOrders)[Customer ID]) This formula will return a table with the following columns: TABLE_NAME: The name of the related table ( SalesOrders ) COLUMN_NAME: The name of the related column ( Customer ID ) CARDINALITY: The cardinality of the relationship (one-to-many) ...

 This is a financial DAX function that returns the accrued interest for a security that pays interest on maturity. Syntax ACCRINTM(<Issue Date>, <Maturity Date>, <Annual Interest Rate>, <Par Value>,<Day count basis>) https://dax.guide/accrintm/

 This is a DAX function that returns the values from a delimited list (delimiter = "|") reading from right to left Syntax PATHITEMREVERSE(<Path>, <Position>, <Type>) Where path is a string with a delimited list of IDS Position is a number reading from right to left Type is an optional parameter that forces the function to return Text (=0) or Integer (=1) https://dax.guide/pathitemreverse/

A mathematical DAX function that returns the hyberbolic Cosine of a number. Syntax COSH(<Number>) https://dax.guide/cosh/

 A time intelligence DAX Function that returns a table with a column of dates showing the dates in the next quarter Syntax NEXTQUARTER(<Dates>) https://dax.guide/nextquarter/

 This is a boolean DAX function that returns true or false if two text strings are exactly the same.  IT IS CASE SENSITIVE Syntax EXACT(<Text1>, <Text2>) https://dax.guide/exact/

 A Financial DAX function that returns the Net Present Value of a schedule of cash flows Syntax XNPV(<Table>, <Values>, <Dates>, <Rate>) where table is the table that has the row whare values and dates expression will be evaluated An expression at the row level that will yield the cash flows An expression that will yield a schedule of  payment dates Rate is the discount rate to be applied to the cash flows https://dax.guide/xnpv/

 This is a DAX function that returns the Unicaode character when provided by the unicdoe numeric number. It uses the UTF-16 Unicode character map Syntax UNICHAR(<Number>) https://dax.guide/unichar/

 This is a financial DAX function that returns the price per $100 of face value of Treasury Bills. Syntax TBILL.PRICE(<Settlement>, <Maturity>, <Discount>) where Settlement is the Settlement Date, Maturity is the Date of Maturity of the Treasury Bill and the Discount is the discount rate  https://dax.guide/tbillprice/

 This is a statistical DAX Function that returns a scalar value representing the Poisson Distribution. Typical use case is to predict a number of events occurring over a specific time. Syntax POISSON.DIST (<x> , <Mean>, <Cummulative>) Where x is the value you want to (target) Mean is the average that  you know Cummulative is a boolean to indicate the probability between 0 and x (TRUE) or the FALSE value where ii is only for x occuring https://dax.guide/poisson-dist/

 A time intelligent DAX function that returns a table with date showing the previous month to the date in the column provided Syntax PREVIOUSMONTH(<Dates>) https://dax.guide/previousmonth/

 This is a statistical DAX function that estimates the Variance based on the entire population that results from evaluating an expression at reach row across a table. Syntax VAR.P(<Table>, <Expression>) https://dax.guide/varx-p/

 This is a mathematical DAX Function that returns the remainder after a number is divided by another number syntax MOD(<Number>, <Divisor>) Examples 2 3 4 5 MOD ( 0 , 2 ) -- returns 0 MOD ( 5 , 2 ) -- returns 1 MOD ( 6 , 3 ) -- returns 0 MOD ( 7 , 3 ) -- returns 1 MOD ( 8 , 3 ) -- returns 2 https://dax.guide/mod/

 A statistical DAX function that returns a scalar value that represents the left tailed T Distrubtion Syntax T.DIST( <X>, <Deg_Freedom>, <Cumalative>) where X is the numeric value at which to evaluate the distribution. Deg_Freedom is an integer value that indicates the number of degrees of freedom Cummalative is a logical value that indicates the form of the function https://dax.guide/t-dist/

 An information DAX function that uses the DMV (Data Model View) and returns a table that shows the model attributes for a given expresssion.  The table has the following fields Field Type ID Integer ModelID Integer Name String Description String Kind Integer Expression String ModifiedTime DateTime QueryGroupID Integer ParameterValuesColumnID Integer MAttributes String LineageTag String SourceLineageTag String RemoteParameterName String ExpressionSourceID Integer https://dax.guide/info-expressions/