I have a two separate data sources that are blending together by site, Business unit and date.
When the date filter is selected as year the values match to the manual values that i have for both datasource A and datasource b. When I select it as a quarter or current month the values in the date source b dont match. I tried blending it with day further it increases the values in data source b. When i remove the relationship for the day wise blending the numbers automatically drop, this is happening when my filter is either quarter or month. however the Year to date values are not being impacted?
Removed all the date connection that is by year ,quarter month and only Used MDY as relationship between both the data sources along with the other relationships and it gave the exact values