Skip to content

Instantly share code, notes, and snippets.

@Erik-H-zz

Erik-H-zz/DaysSinceLastSale.dax

Created March 1, 2022 17:27
Show Gist options
  • Save Erik-H-zz/6d82ea3622470ef2232720c60c4c092f to your computer and use it in GitHub Desktop.
Save Erik-H-zz/6d82ea3622470ef2232720c60c4c092f to your computer and use it in GitHub Desktop.
Download ZIP
The amount of days between the previous sale and the current one.
Raw
DaysSinceLastSale.dax
Days since last sale =
DATEDIFF(
[Previous Date of Sales]
, MIN(FactInternetSales[OrderDate])
, DAY
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment