Forum Discussion
Calculating ARR
Hi, I would like to calculate ARR, this is a sum of the ACV for a given month-year. I have the following Contract Table: When the contract ends the Value is 0. Client Name Client N...
zameenakarmali , This is data type error
Try using
dax
ARR =
VAR SelectedDate = MAX(Dim_Date[Date])
RETURN
CALCULATE(
SUM(Contract[ACV]),
FILTER(
Contract,
Contract[Month Added] <= SelectedDate &&
Contract[End Quarter] >= SelectedDate
)
)
The issue is that we are comparing the Quarters which is a text field to Month-Year which is a date column