Filter a column using another column

[Sonalin]

I am tryin to calculate quarter  over quarter groth in power BI. My client used diffrent fisacl calender 

I Have Quarter ID and Bookings column in my table I need to get value of last year same quarte booking in third column please help. for example in calculated column I need to get valule for 2016Q1 QoQBookings net (1,003,363,413.19 - 2015Q1 bookings net)

[v-chuncz-msft · Accepted solution]

@Sonalin,

You may add a calculated column as follows.

Column =
LOOKUPVALUE (
    Table1[Bookings Net],
    Table1[Fiscal Quarter ID], ( LEFT ( Table1[Fiscal Quarter ID], 4 ) - 1 )
        & RIGHT ( Table1[Fiscal Quarter ID], 2 )
)