Slicer with multiple tables (daily and not daily data)

[paris]

Hi All,

Please help. When I select city and time range by slicers, I want to show two daily graphs.
however, Sales data is when it is sold, Sales target is monthly basis while temperature is daily basis. It makes complicated to set up relationship. 

All the best,
Paris

[v-easonf-msft · Accepted solution]

Hi, @paris 

You can try to create a inactive relationship between field Monthly(calendar) and field 'Date'(calenadar) ：

Then use function 'userelationship' create measure 'Target(monthly)'  as below:

Target(monthly) = CALCULATE(sum('Sales Target'[Target]),USERELATIONSHIP('Calendar'[Monthly],'Sales Target'[Monthly]))

The result will show as below:

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@paris , You can use month start date or month end date(Target) and join it with date table on date

refer this video :https://www.youtube.com/watch?v=yPQ9UV37LOU