Average YTD

[Sofie]

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?

[Anonymous · Accepted solution]

@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
    ))

[Sofie]

Thank you for the fast respond, it seems to work 🙂