Previous Date
=
ALLNOBLANKROW
(
'Date'
)
Previous Sales :=
CALCULATE
(
[Sales Amount],
ALL
(
'Date'
),
USERELATIONSHIP
(
'Date'[Date],
'Previous Date'[Date]
)
)
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi