Contents:

DAX (Data Analysis Expression), Explicit measures, Iteration (X), Calculate function, Logical operators (AND, OR), IN IF, NESTEDIF, SWITCH, DIVIDE, ISERROR, Multiply, Subtract, LEN, LEFT, RIGHT, FIND, DATE Fns (TODAY, NOW) Column level measure, Substitute(), Replace(), Table level measure, Summarize(), Group by(), CurrentGroup(), Calendar(), Date(), Format(), Quarter(), Year(), Month(), Calendarauto(), Fiscal/Financial Year table, Edate(), Merge columns [& ,Concatenate(), Combinevalues()], Dynamic title [selectedvalue(), Concatenatex(), Value()] Isinscope(),Iffiltered(), Field parameter [Measure Slicer], Group [List, bins], Remove Filter[All()]