Sponsor of the Day:
Jerkmate
https://dax.guide/info-storagefiles/
INFO.STORAGEFILES – DAX Guide
Returns a list of all storage files in the current model with columns matching the schema rowset for storage file objects.
dax guideinfo
https://dax.guide/dt/decimal/
Decimal – DAX Guide
A decimal number is always stored as a double-precision floating point value. Do not confuse this DAX data type with the decimal and numeric data type of Tr
dax guidedecimal
https://dax.guide/info-formatstringdefinitions/
INFO.FORMATSTRINGDEFINITIONS – DAX Guide
dax guideinfo
https://dax.guide/linest/
LINEST – DAX Guide
Uses the Least Squares method to calculate a straight line that best fits the data, then returns a table describing the line. The equation for the line is of...
dax guide
https://dax.guide/hour/
HOUR – DAX Guide
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
dax guidehour
https://dax.guide/alwaysapply/
ALWAYSAPPLY – DAX Guide
Modifies how filters are applied while evaluating a GROUPCROSSAPPLY or GROUPCROSSAPPLYTABLE function.
dax guide
https://dax.guide/nominal/
NOMINAL – DAX Guide
Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
dax guidenominal
https://dax.guide/rownumber/
ROWNUMBER – DAX Guide
Returns the unique rank for the current context within the specified partition sorted by the specified order or on the axis specified.
dax guide
https://dax.guide/keywordmatch/
KEYWORDMATCH – DAX Guide
Returns TRUE if there is a match between the MatchExpression and Text.
dax guide
https://dax.guide/runningsum/
RUNNINGSUM – DAX Guide
Calculates a running sum along the specified axis of the Visual Calculation data grid.
dax guide
https://dax.guide/st/return/
RETURN – DAX Guide
The RETURN keyword consumes variables defined in previous VAR statements. The result_expression has access to all the variables (name, name2, …) defin
dax guidereturn
https://dax.guide/isdecimal/
ISDECIMAL – DAX Guide
Checks whether a value is a fixed precision decimal number (currency), and returns TRUE or FALSE. This is an alias of ISCURRENCY.
dax guide
https://dax.guide/isselectedmeasure/
ISSELECTEDMEASURE – DAX Guide
Returns true if one of the specified measures is currently being evaluated.
dax guide
https://dax.guide/nextmonth/
NEXTMONTH – DAX Guide
Returns a next month.
dax guide
https://dax.guide/
DAX Guide
The definite reference to the DAX formula language.
dax guide
https://dax.guide/info-partitionstorages/
INFO.PARTITIONSTORAGES – DAX Guide
Returns a list of all partition storages in the current model with columns matching the schema rowset for partition storage objects.
dax guideinfo
https://dax.guide/month/
MONTH – DAX Guide
Returns a number from 1 (January) to 12 (December) representing the month.
dax guidemonth
https://dax.guide/st/mparameter/
MPARAMETER – DAX Guide
The MPARAMETER keyword defines the value of a parameter used in Power Query for a dynamic M parameter in DirectQuery connections. The name corresponds to th
dax guide
https://dax.guide/power/
POWER – DAX Guide
Returns the result of a number raised to a power.
dax guidepower
https://dax.guide/info-extendedproperties/
INFO.EXTENDEDPROPERTIES – DAX Guide
Returns a list of all extended properties in the current model with columns matching the schema rowset for extended properties objects.
dax guideinfo
https://dax.guide/dt/integer/
Integer – DAX Guide
The DAX Integer data type stores a 64-bit value. DAX does not have other integer data types with a smaller number of bits. All the internal calculations bet
dax guideinteger
https://dax.guide/ppmt/
PPMT – DAX Guide
Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
dax guide
https://dax.guide/endofmonth/
ENDOFMONTH – DAX Guide
Returns the end of month.
dax guide
https://dax.guide/gcd/
GCD – DAX Guide
Returns the greatest common divisor of two integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a...
dax guidegcd
https://dax.guide/info-parquetfilestorages/
INFO.PARQUETFILESTORAGES – DAX Guide
dax guideinfo
https://dax.guide/second/
SECOND – DAX Guide
Returns a number from 0 to 59 representing the second.
dax guidesecond
https://dax.guide/pricemat/
PRICEMAT – DAX Guide
Returns the price per $100 face value of a security that pays interest at maturity.
dax guide
https://dax.guide/tojson/
TOJSON – DAX Guide
Converts the records of a table into a JSON text.
dax guidetojson