Creating a table contains Avg Days prior Closing per BU

[cruzp]

Hello, 

I have a data model below where I have the fact tables that links to two dimensional table both have many to one relationship.

DIM_COST_CENTER does not have a relationship to DIM_OPPORTUNITY.

My goal is to have a table like below: 

Business Unit is from the table 'DIM_COST_CENTER'

Avg Days Close should be the difference between Closed Date and Created Date from table 'DIM_OPPORTUNITY'

I wanted to create the Avg Days Close within my fact table but I could not able to call the date fields from 'DIM OPPORTUNITY'

And create a table for Avg Days Close per Business Unit.

Please help how do I do it.

[DataVitalizer · Accepted solution]

Hi @cruzp 

In order to get the exact values edit the relationship between FACT and 'DIM OPPORTUNITY' and set the cross filter direction to 'Both'

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated