DAX Functions
Find Power BI practice exercises by DAX function.
Each function page groups the concepts that use that function, so learners can move from one related PBIX exercise to the next.
59Functions and patterns
Function Library
*2 conceptsADDCOLUMNS1 conceptALL3 conceptsALLEXCEPT1 conceptALLSELECTED1 conceptAND1 conceptAND (or && operator)1 conceptArithmetic Operators (+1 conceptAVERAGE3 conceptsAVERAGEX7 conceptsbasic arithmetic operators (+1 conceptBLANK1 conceptCALCULATE26 conceptsCalculated Columns1 conceptCONCATENATEX4 conceptsCONTAINSSTRING4 conceptsCOUNTROWS7 conceptsCROSSFILTER1 conceptData Modeling for Date Comparison1 conceptDate Table Setup & Configuration1 conceptDATEADD4 conceptsDATESINPERIOD1 conceptDATESQTD1 conceptDATESYTD2 conceptsDIVIDE19 conceptsEARLIER2 conceptsEVALUATE1 conceptFILTER7 conceptsHASONEVALUE2 conceptsIF5 conceptsISBLANK5 conceptsISERROR1 conceptISFILTERED2 conceptsISINSCOPE1 conceptKEEPFILTERS2 conceptsMAX1 conceptMIN1 conceptOR1 conceptORDER BY1 conceptPARALLELPERIOD1 conceptPREVIOUSMONTH1 conceptRANKX1 conceptRELATED5 conceptsRELATEDTABLE1 conceptREMOVEFILTERS3 conceptsRETURN1 conceptSAMEPERIODLASTYEAR2 conceptsSELECTEDVALUE3 conceptsSUM9 conceptsSUMMARIZE3 conceptsSUMX7 conceptsSWITCH3 conceptsTOTALMTD1 conceptTOTALQTD1 conceptTOTALYTD2 conceptsUSERELATIONSHIP1 conceptVALUES6 conceptsVAR5 conceptsYEAR1 concept