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...
change this part
VAR threemonths = DATEADD(Bookings[Order Intake Date],3,MONTH)
to run against the Bookings' Dates table instead.
VAR threemonths = DATEADD(Date_Booked[Date],3,MONTH)
There was a change but now my error is "a table of multiple values was supplied where a single value was expected".
Check your code. Especially this part
'Measure'[3 months]
looks suspicious.