SHARE
TWEET

Untitled

a guest Jun 20th, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CALCULATE([Sold Dollars],
  2.           'calendar'[Date] <= TODAY()-1) && 'calendar'[Date] >= TODAY()-7)
  3.      
  4. CALCULATE([Sold Dollars],
  5.           'calendar'[Date] <= MAX('calendar'[Date])-1
  6.           && 'calendar'[Date] >= MAX('calendar'[Date])-7)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top