Problem with Moving Average 12

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

Anonymous - One, I would personally avoid DATESINPERIOD. https://community.powerbi.com/t5/Quick-Measures-Gallery/To-bleep-With-DATEADD/m-p/1259467#M583

You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Finally, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

// For this stuff to work you need
// Calendar (a date table in the model).

[12D MA] =
var __maxVisibleDay = MAX( 'Calendar'[Date] )
var __countOfDaysToAvgOver = 12
var __datesToAvgOver =
    TOPN( __countOfDaysToAvgOver,
        // This table gets you the correct
        // number of days of the correct
        // type but you have to remember
        // that you might be too close
        // to the beginning of the
        // Calendar and in fact you'll
        // get fewer days than needed.
        CALCULATETABLE(
            VALUES( 'Calendar'[Date] ),
            'Calendar'[DayType] = "Weekday",
            'Calendar'[Date] <= __maxVisibleDay,
            ALL( 'Calendar' )
        ),
        'Calendar'[Date],
        DESC
    )
// This check is needed in case there
// are not enough days in the calendar
// (see the comment above).
var __thereAreEnoughDays =
    COUNTROWS( __datesToAvgOver )
        = __countOfDaysToAvgOver
return
if( __thereAreEnoughDays,
    CALCULATE(
        AVERAGEX(
            __datesToAvgOver,
            [Total Precios]
        ),
        // This directive is probably not
        // needed but only if 'Calendar'
        // is a proper Date table in
        // the model. But you can leave it
        // in as it works in any setting.
        ALL( 'Calendar' )
    )
)