Forum Discussion

Sofie's avatar
Sofie
Regular Visitor
8 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    8 years ago

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

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Sofie
Regular Visitor
8 years ago

Thank you for the fast respond, it seems to work :)