Forum Discussion

Sonalin's avatar
Sonalin
Regular Visitor
8 years ago
Solved

Filter a column using another column

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's avatar
    v-chuncz-msft
    8 years ago

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

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

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