Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DATEADD not aggregating

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...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Try like

Revenue:
var _book =Bookings[Order Intake Date]
3 months =
VAR threemonths = DATE(year(_book),month(_book) +3,day(_book))
RETURN
CALCULATE([Sum Revenue Recognized], Revenue[Posting Date] <= threemonths)

% Converted = CALCULATE(DIVIDE('Measure'[3 months],[Sum Order Value]))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks amitchandak 

So when I try to use 

var _book = Bookings[Order Intake Date] it won't let me reference the column

 

It says a single value for column 'Order Intake Date' in table 'Bookings' cannot be determined.