Forum Discussion
'DATEADD' Expects a contiguous selection
Hello, I'm trying to create a measure where I calculate revenue recognized on a sales order in specific timeframes (see below table). I'm using two measures calculating revenue then % of revenue ag...
General guidance is that your data model should contain a calendar/dates table that covers your fact date range (plus a year before) and that has contiguous dates. You'll also want to mark the table as a Date table to avoid wasting model memory.
Then run the DATEADD() against the dates table.
If you don't want to do that you can use EDATE() for month math. It doesn't care about contiguity (sp?)
EDATE, yes that's the one!
Just want an equivalent of DATEADD in SQL, albeit will only work for months, but that's just what I need and without all the fuss.