I have 2 fact table & 2 period dimension table
Where there are relation ship between
FACT_SALES_ACTUAL --> DIM_PERIOD --> DIM_MONTH_PERIOD
FACT_SALES_BUDGET --> DIM_MONTH_PERIOD
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 ..