Time Intelligence DAX | Current, Previous & SamePeriodLastYear | MTD QTD YTD | MoM QoQ YoY POWER BI

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]))