count the accounts by matching two date columns from two different tables.

[Anonymous]

I have three tables.
1. Main Calender table

2. Table x which contains a date column + other columns which has uniq customers
3. Table Y which also contains a date column + Other columns which doesnt have uniq cust

Diagram.

Main calender (one:many) Table x which is active.

Main calender (one:many) table y which is inactive.

Table x (one:many) table y which is active (based on unique cust)

Result required on columns

Date by year and month II  Sales completed (count of uniq customers in table x II Gross churn (if date column (table y) > date (table x) count and displayII


I tried using selected value, userrelationship but no luck. Other way that I thought of was using related and adding the table y date column in x and create two other column in the table but it inst the best way. Any suggestions using dax?

    

[v-henryk-mstf]

Hi @Anonymous ,

I don't seem to understand this paragraph, can you explain and describe it in detail?

It should be noted that no relationship can be established between the two tables, otherwise it will cause logical errors. tablex in the statistics of customer sales, how to make a judgment on the date in the two tables, the result of the judgment is to get what results?

Looking forward to your feedback.

Best Regards,
Henry

[amitchandak]

@Anonymous , Ideally in this model X should not join with Y.

If need you should create a common customer table and join with both  and use customer from there

customer= distinct(union(distinct(X[customer]), distinct(Y[customerl])))

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19