Forum Discussion

hxkresl's avatar
hxkresl
Icon for Advocate III rankAdvocate III
9 years ago

Related: pulling in a column into a Fact table from a look up table

I am trying to bring a copy of the Application Name into the mc_alerts table, by creating a Column using RELATED.  That does not work.

Reason: I need to show relationship between lineofbusiness and applications on a pivot table 

 

How to do it?   for every alert, there is an applciation affected, so it should be possible. 

 

Need Help

1 Reply

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

    Hi hxkresl,

    In mc_mc_alert_mc_applicationset table, you can create a calculated column using RELATED function.

     

     

    AppName=RELATED(mc_Applications[ApplicationName])


    Then create a calculated column in mc_alerts table like the formula. Please replace the [A] and [B] columns as your actual related table.

    AppName1= CALCULATE(FIRSTNONBLANK(mc_mc_alert_mc_applicationset[AppName],1),USERELATIONSHIP(mc_alerts[A],mc_mc_alert_mc_applicationset[B]))


    Best Regards,
    Angelia