R12 data - the bane of my life!

DAX DAX Calculations
3

Hi @NeilR1,

Welcome to the forum!
Thanks for providing so much detail and a PBIX :+1:

See if this works for you

Rolling 12M = 
CALCULATE( [Available Hours],
    DATESBETWEEN( Dates[Date],
        NEXTDAY ( SAMEPERIODLASTYEAR ( ENDOFMONTH( ( Dates[Date] ) ) )),
        ENDOFMONTH( ( Dates[Date] ))
    )
)

As for your second question you could use a “Relative date” filter on Dates[Date] or if you are using the Extended Date table M function use Offsets to filter to a specific period only.

I hope this is helpful

1 Like