Forum Discussion
Helper IDate filtering and relationship
Hi， hgalfre ；
There are two methods:
1.One is to create many-to-many relationships between dates in "Actual Sales table" and "Actual Target table", and delete other relationships or make them inactive.The final output is shown below:
2.The second method is to join the date inactive relationship between the two tables and create the measure using USERELATIONSHIP().
Then create a measure.
sale2 = CALCULATE(SUM('Actual sales table'[Sales]),USERELATIONSHIP('Actual sales table'[Date],'Actual target table'[Date]))The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi， hgalfre ；
There are two methods:
1.One is to create many-to-many relationships between dates in "Actual Sales table" and "Actual Target table", and delete other relationships or make them inactive.
The final output is shown below:
2.The second method is to join the date inactive relationship between the two tables and create the measure using USERELATIONSHIP().
Then create a measure.
sale2 = CALCULATE(SUM('Actual sales table'[Sales]),USERELATIONSHIP('Actual sales table'[Date],'Actual target table'[Date]))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThanks for your quick reply! it seems to be working