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 q...
  • 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 )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity 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 )
)