-
FLOOR: Rounds a number down, toward zero, to the nearest multiple of significance. https://dax.guide/floor/ MROUND: Returns a number rounded to the desired multiple. https://dax.guide/mround/ CEILING: Rounds a number up, to the nearest integer or to the nearest unit of significance.… Watch now
-
ROUND: Rounds a number to a specified number of digits. https://dax.guide/round/ ROUNDDOWN: Rounds a number down, toward zero. https://dax.guide/rounddown/ ROUNDUP: Rounds a number up, away from zero. https://dax.guide/roundup/ TRUNC: Truncates a number to an integer by removing the decimal, or… Watch now
-
ISLOGICAL: Checks whether a value is a logical value (TRUE or FALSE). https://dax.guide/islogical/ ISNONTEXT: Checks whether a value is not text. https://dax.guide/isnontext/ ISNUMBER: Checks whether a value is a number. https://dax.guide/isnumber/ ISTEXT: Checks whether a value is text. https://dax.guide/istext/ Watch now
-
FIRSTNONBLANK: Returns the first value in the column for which the expression has a non blank value. https://dax.guide/firstnonblank/ LASTNONBLANK: Returns the last value in the column for which the expression has a non blank value. https://dax.guide/lastnonblank/ FIRSTNONBLANKVALUE: Returns the first… Watch now
-
NOW: Returns the current date and time in datetime format. https://dax.guide/now/ TODAY: Returns the current date in datetime format. https://dax.guide/today/ UTCNOW: Returns the current date and time in datetime format expressed in Coordinated Universal Time (UTC). https://dax.guide/utcnow/ UTCTODAY: Returns the… Watch now
-
COUNT: Counts the number of rows in the table where the specified column has a non-blank value. https://dax.guide/count/ COUNTA: Counts the number of values in a column. https://dax.guide/counta/ COUNTAX: Counts the number of values which result from evaluating an expression… Watch now
-
video
DAX Formatter
If it’s not formatted, it’s not DAX! Learn all the settings of DAX Formatter and how you can improve your DAX measures and DAX queries, also in DAX Studio and Tabular Editor. Transform your code in real DAX! 00:00 –… Watch now
-
Discover how we implemented the new DAX.do service. We received several questions about connecting DAX.do to other databases or replacing DAX Studio… Don’t worry: DAX Studio is here to stay, and DAX.do has a specific educational goal. But understanding how… Watch now
-
Every Power BI model has dates and the need for calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and standard time intelligence functions in DAX can help, but how do… Watch now
-
OPENINGBALANCEMONTH: Evaluates the specified expression for the date corresponding to the end of the previous month. https://dax.guide/openingbalancemonth/ OPENINGBALANCEQUARTER: Evaluates the specified expression for the date corresponding to the end of the previous quarter after applying specified filters. https://dax.guide/openingbalancequarter/ OPENINGBALANCEYEAR: Evaluates… Watch now
