Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Problem with Moving Average 12

Hi.   I have an issue. I was trying to replicate the formula from this post: https://community.powerbi.com/t5/Desktop/5-Day-Moving-average-No-Weekends-in-Data-and-how-I-skip-weekends/m-p/133197#M56...
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
6 years ago

Hi, there

 

Weekends are supposed to be filtered out in Tecnicos[FECHA] column beforehand;

or filter down Tecnicos[FECHA] if it contains all consecutive dates

 

 

_12workdays =
TOPN (
    12,
    CALCULATETABLE (
        VALUES ( Calendar[Date] ),
        NOT WEEKDAY ( Calendar[Date] ) IN { 1, 7 },
        FILTER ( ALL ( Calendar[Date] ), Calendar[Date] <= MAX ( Calendar[Date] ) )
    )
)