Solved: Filter a column using another column

Sonalin · ‎01-24-2018

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 · ‎01-24-2018

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎01-24-2018

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.