Hi Sam
ahh! think i am now starting to get the logical! The reason why I have been so eager to learn this is simply put I think its a great pieice of analysis for anyone to have!
So just to make sure I am on the righr right I could use LASTDATE dax function instead of using TODAY because likely in my situation my date, data set will not have"Today date for me to use TODAY dax function. So i could just change below to LASTDATE.
Revenue Timeframe = CALCULATE([Total Revenue],
FILTER('Date',
'Date'[Date]<=TODAY() && 'Date'[Date]>=TODAY() - [Time Frame Selected]))
This is mine version of the multi day.
