rolling 12 months previous month of today in powerbi

[Anonymous]

hi

I was half way done with DAX calculated column but i need help in calculating the rolling 12 months from previous complted month  which i was not able to figure it out . can you please help here ?

what i was able to figure it out is rolling 12 months from today using below formula .can anyone help with previous completed month to rolling 12 months back from today will work for me .

Last12Months =

VAR

    LDATE = TODAY()

VAR

    FDATE = EDATE(LDATE,-12)

RETURN

if( Query1[BATCHDATE] < LDATE && Query1[BATCHDATE]>FDATE,"True","False")

[v-yuta-msft · Accepted solution]

@Anonymous ,

You may modify your measure as below:

Last12Months =
VAR LDATE =
    TODAY ()
VAR FDATE =
    EOMONTH ( LDATE, -13 ) + 1
RETURN
    IF ( Query1[BATCHDATE] < LDATE && Query1[BATCHDATE] >= FDATE, "True", "False" )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.