Skip to content

Instantly share code, notes, and snippets.

@Erik-H-zz

Erik-H-zz/ValueofPreviousDateSales.Dax

Created March 1, 2022 17:25
Show Gist options
  • Save Erik-H-zz/04bfa1a6b3d66d20144ca9af99da6a40 to your computer and use it in GitHub Desktop.
Save Erik-H-zz/04bfa1a6b3d66d20144ca9af99da6a40 to your computer and use it in GitHub Desktop.
Download ZIP
Get the value of the previous sales date
Raw
ValueofPreviousDateSales.Dax
Value of Previous Date Sales =
VAR PreviousDate = [Previous Date of Sales]
RETURN
CALCULATE(
[Sum Amount]
,'FactInternetSales'[OrderDate] = PreviousDate
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment