Filter Data per month from two tables

[Anonymous]

Hello,

I'm not sure if my problem is a model problem or a reporting one,

I have 3 related tables, using the following structure.

 

I want to display the cost of each user in Except O365_HR ( measure exists in AFFECTATIONS table ) per month,

Since there's no relation based on the date between the two tables, I'm getting some incorrect costs.

Filtering with Except O365_HR[Date] will get the rights users with wrong costs ( for example if the users exist n EXCEPT_O365_HR in only January, it will display the cost of January and February of this user because he exists in both months in the AFFECTATIONS table)

Using the AFFECTATIONS[date] filter will get the right costs for each user but will also display users that don't exist in the EXCEPT_O365_HR table in this filtered month.

Can you please help me find the logic to do this ?

[Anonymous]

@amitchandak 

I have created a sample pbix to describe the issue, how can i share it with you ?

[Anonymous]

Ofc @amitchandak,

The filter here is when using affectation (lastUpdate), correct cost with wrong users : 

This one is when using Except O365_HR (lastUpdate) filter, correct users with wrong cost:

Thank you.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.