Forum Discussion
Average YTD
Hi,
To calculate my average YTD I need to have the days I produced on since the first of January this year. So I can divide my YTD to this number.
I tried this code:
Cumulative Quantity test =
CALCULATE (
distinctcount(EBAN[Requisition Date]);
FILTER (
ALLSELECTED( 'Date'[Date]);
DATE(YEAR('Date'[Date]);01;01) <= 'Date'[Date] <= MAX ( 'Date'[Date] )
))
but it doesn't seem to work.. Does anyone have an idea how i can make it work?
Sofie try this
Cumulative Quantity test =
VAR MaxDate = CALCULATE(MAX('Date'[Date]))
Return CALCULATE (
distinctcount(EBAN[Requisition Date]);
FILTER (
ALLSELECTED(EBAN);
EBAN[Requisition Date] >= DATE(YEAR(MaxDate),'01','01') && EBAN[Requisition Date] < MaxDate
))
2 Replies
Sofie try this
Cumulative Quantity test =
VAR MaxDate = CALCULATE(MAX('Date'[Date]))
Return CALCULATE (
distinctcount(EBAN[Requisition Date]);
FILTER (
ALLSELECTED(EBAN);
EBAN[Requisition Date] >= DATE(YEAR(MaxDate),'01','01') && EBAN[Requisition Date] < MaxDate
))Thank you for the fast respond, it seems to work :)
