Forum Discussion

jonasarnout's avatar
jonasarnout
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Link data in Power BI

Hi My goal is to link schedule information from our schedule app to historic voyages from an Oracle database of an ERP system. The schedule information needs to be enriched so that i can see the la...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi jonasarnout,

    If there is relationship between 'Voy Calc Req SN' and 'Schedule App Qry'? You create a measure rather than calculated column, right? If it is, please use the formula below and check if it works fine.

    =
CALCULATE (
    FIRSTNONBLANK ( 'Voy Calc Req SN'[TRADE], 'Voy Calc Req SN'[TRADE] ),
    FILTER (
        'Voy Calc Req SN',
        [SHIP] = 'Schedule App Qry'[ship]
            && [VOY] = 'Schedule App Qry'[Last Voyage]
    )
)


    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi jonasarnout,

If there is relationship between 'Voy Calc Req SN' and 'Schedule App Qry'? You create a measure rather than calculated column, right? If it is, please use the formula below and check if it works fine.

=
CALCULATE (
    FIRSTNONBLANK ( 'Voy Calc Req SN'[TRADE], 'Voy Calc Req SN'[TRADE] ),
    FILTER (
        'Voy Calc Req SN',
        [SHIP] = 'Schedule App Qry'[ship]
            && [VOY] = 'Schedule App Qry'[Last Voyage]
    )
)


Best Regards,
Angelia

  • jonasarnout's avatar
    jonasarnout
    Icon for Advocate I rankAdvocate I
    8 years ago

    Hi Angelia

     

    your formula works great!

    I have used it to create a calculated column instead of a measure.

     

    I would use a measure for operations with agregates.

    the trade is text and will be used as a row filter hence a column seems more logical to me.

     

    what is your motivation to suggest a measure instead of a calculated column in this case?