Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter Data per month from two tables

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 ?

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak 

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