Recent | Popular
#ms.pbi #dax #dax.sameperiodlastyear #same.period.last.year #dax.calculate
LY Sales 2 = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR( 'Calendar'[Date] ) )
#ms.pbi #dax #dax.sumx #dax.sameperiodlastyear #same.period.last.year
LY Sales 1 = SUMX ( SAMEPERIODLASTYEAR( ' Calendar'[Date] ), [Total Sales] )
Mon Jan 01 2024 09:50:13 GMT+0000 (Coordinated Universal Time)
Mon Jan 01 2024 09:48:39 GMT+0000 (Coordinated Universal Time)