May 28, 2013 at 4:37 am
Hi there,
I have 2 fact table & 2 period dimension table
FACT_SALES_ACTUAL :
PERIOD_DAY_KEY
SALES_AMOUNT
FACT_SALES_BUDGET :
PERIOD_MONTH_YEAR_KEY
SALES_BUDGET
DIM_PERIOD :
PERIOD_DAY_KEY
DAY_DESC
MONTH_YEAR_DESC
PERIOD_MONTH_YEAR_KEY
YEAR_DESC
DIM_MONTH_PERIOD :
PERIOD_MONTH_YEAR_KEY
MONTH_YEAR_DESC
YEAR_DESC
Where there are relation ship between
FACT_SALES_ACTUAL --> DIM_PERIOD --> DIM_MONTH_PERIOD
FACT_SALES_BUDGET --> DIM_MONTH_PERIOD
questions :
how to make a DAX query of measurement of Sales Budget so it can be displayed side by side with Sales Actual measurement, in daily basis with correct relationship of month-year ?
I've tried once, bu it always show the sales Budget in every single period of day,including with unmatch period of month-year ..
please help
Thanks
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply