Measure. Calculate. Filter.
Tap for definition · Hold to copyHover for definition · Click to copy
AggregationSUMSUMXAVERAGEAVERAGEXGEOMEANGEOMEANXMIN / MAXMINX / MAXXCOUNTCOUNTACOUNTROWSCOUNTBLANKDISTINCTCOUNTCOUNTXPRODUCTPRODUCTX CALCULATE & Filter ContextCALCULATECALCULATETABLEFILTERALLALLEXCEPTALLSELECTEDALLNOBLANKROWREMOVEFILTERSKEEPFILTERSALLCROSSFILTEREDCROSSFILTERUSERELATIONSHIP DAX StatementsVAR / RETURNMultiple VARCOLUMNORDER BY Logical & ConditionalIFSWITCHSWITCH(TRUE())IFERRORCOALESCEBLANKAND / ORNOT Time IntelligenceTOTALYTDTOTALQTDTOTALMTDDATESYTDDATESQTDDATESMTDSAMEPERIODLASTYEARDATEADDPARALLELPERIODPREVIOUSMONTHPREVIOUSQUARTERPREVIOUSYEARNEXTMONTHNEXTYEARDATESBETWEENSTARTOFMONTHENDOFMONTHSTARTOFQUARTERENDOFQUARTERSTARTOFYEARENDOFYEAR Date & TimeTODAYNOWDATEDATEVALUEYEAR / MONTH / DAYQUARTERWEEKDAYWEEKNUMDATEDIFFEOMONTHEDATEFORMAT (date)CALENDARCALENDARAUTO TextEXACTCONCATENATECONCATENATEXLEFT / RIGHTMIDLENFINDSEARCHSUBSTITUTEREPLACEUPPER / LOWERTRIMVALUEFORMAT (text) Relationship & VirtualRELATEDRELATEDTABLETREATASUSERELATIONSHIPCROSSFILTER Table FunctionsSUMMARIZESUMMARIZECOLUMNSGROUPBYADDCOLUMNSSELECTCOLUMNSDISTINCTVALUESTOPNNATURALINNERJOINNATURALLEFTOUTERJOINUNIONINTERSECTEXCEPTROWGENERATESERIES InformationSELECTEDVALUEHASONEVALUEHASONEFILTERISFILTEREDISCROSSFILTEREDISINSCOPEISBLANKISNUMBERISTEXTISLOGICALISERRORNAMEOFUSERPRINCIPALNAMEFIRSTNONBLANKLASTNONBLANK Math & StatsDIVIDEROUNDROUNDUP / ROUNDDOWNINTTRUNCABSMODPOWERSQRTSIGNMEDIANMEDIANXPERCENTILE.INCSTDEV.P / STDEV.S DAX Operators= (equal)== (strict equal)> / < / >= / <=<> (not equal)+ - * / ^& (concatenation)&& (logical AND)|| (logical OR)IN { } (list test)