Time Intelligence DAX | Current, Previous & SamePeriodLastYear | MTD QTD YTD | MoM QoQ YoY POWER BI
#DAX #POWERBI
TotalSales = SUM(balances[Amount])
Current MTD = TOTALMTD([TotalSales],DATESMTD(balances[Dates]))
Current QTD = TOTALQTD([TotalSales],DATESQTD(balances[Dates]))
Current YTD = TOTALYTD([TotalSales],DATESYTD(balances[Dates]))
Previous MTD = CALCULATE([TotalSales],PREVIOUSMONTH(DATESMTD(balances[Dates])))
Previous QTD = CALCULATE([TotalSales],PREVIOUSQUARTER(DATESQTD(balances[Dates])))
Previous YTD = CALCULATE([TotalSales],PREVIOUSYEAR(DATESYTD(balances[Dates])))
SPLY MTD = CALCULATE([Current MTD],SAMEPERIODLASTYEAR(balances[Dates]))
SPLY QTD = CALCULATE([Current QTD],SAMEPERIODLASTYEAR(balances[Dates]))
SPLY YTD = CALCULATE([Current YTD],SAMEPERIODLASTYEAR(balances[Dates]))