https://learn.microsoft.
com/en-us/dax/dax-function-reference
Calcualted Tables:
==================
Sum_Orders = SUMMARIZE(Orders,Orders[Category],Orders[Sales])
Summarize_Orders = SUMMARIZE(Orders,Orders[Region],Orders[Category],Orders[Sales])
Summarize_Orders_new = SUMMARIZE(Orders,Orders[Region], Orders[Category],"Total
Sales",SUM(Orders[Sales]))
Summarize_OS = SUMMARIZE(FILTER(Orders,Orders[Category]="Office
Supplies"),Orders[Region],"Total Profit",SUM(Orders[Profit]))
Orders_Central_Tech = FILTER(Orders,Orders[Region] = "Central" && Orders[Category]
= "Technology" && Orders[Segment] = "Consumer")
Calculated Measures:
====================
TotalSales = SUM(Orders[Sales])
Time Intelligence DAX Functions:
================================
Total_YTD = CALCULATE(SUM(Orders[Sales]),DATESYTD(Orders[Order Date]))
Sales_QTD = CALCULATE(SUM(Orders[Sales]),DATESQTD(Orders[Order Date]))
Sales_MTD = CALCULATE(SUM(Orders[Sales]),DATESMTD(Orders[Order Date]))
Is_Age_Sal_Blank = AND(ISBLANK(Sample_Table[Age]),ISBLANK(Sample_Table[Salary]))
Is_Age_Sal_Blank = AND(ISBLANK(Sample_Table[Age]),ISBLANK(Sample_Table[Salary]))
Age_Or_Sal = OR(ISBLANK(Sample_Table[Age]),ISBLANK(Sample_Table[Salary]))
Age_Or_Sal = OR(ISBLANK(Sample_Table[Age]),ISBLANK(Sample_Table[Salary]))
Performance = IF(Orders[Sales]>5000,"Excellent",IF(Orders[Sales]>1000,"Very
Good","Poor"))
