-
This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Read more
-
This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. Read more
-
This article describes how to control format strings in calculation groups. Before starting, we suggest you read the previous articles in this series. Read more
-
String DAX data type: Every string in DAX is stored as a Unicode string, where each character is stored in 16 bits. https://dax.guide/dt/string/ Watch now
-
The DAX Integer data type stores a 64-bit value. DAX does not have other integer data types with a smaller number of bits. https://dax.guide/dt/integer/ Watch now
-
UNICHAR: Returns the Unicode character that is referenced by the given numeric value. https://dax.guide/unichar/ UNICODE: Returns the number (code point) corresponding to the first character of the text. https://dax.guide/unicode/ Watch now
-
LOWER: Converts all letters in a text string to lowercase. https://dax.guide/lower/ UPPER: Converts a text string to all uppercase letters. https://dax.guide/upper/ Watch now
-
CONCATENATE: Joins two text strings into one text string. https://dax.guide/concatenate/ CONCATENATEX : Evaluates expression for each row on the table, then return the concatenation of those values in a single string result, seperated by the specified delimiter. https://dax.guide/concatenatex/ Watch now
-
NATURALINNERJOIN: Joins the Left table with right table using the Inner Join semantics. https://dax.guide/naturalinnerjoin/ NATURALLEFTOUTERJOIN: Joins the Left table with right table using the Left Outer Join semantics. https://dax.guide/naturalleftouterjoin/ Watch now
-
GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table with these results. https://dax.guide/generate/ GENERATEALL: The second table expression will be evaluated for each row in the first… Watch now