DAX: is it possible to join two tables M:M relationship?

[hxkresl]

Since model doesn't allow, can DAX be used to join two standalone table on columns eg. Datekey, which are not unique to the row in either table?  I can do it in SQL.  I have datekeys in left table that match datekeys in right table and i do an inner join to return all matches.

I can't model this in Desktop, but can I do this with DAX and return a full table result?

[Eric_Zhang]

@hxkresl

In below case, table1 and table3 are Many to Many

"can DAX be used to join two standalone table on columns"

You could try a CROSSJOIN with filters or NATURALINNERJOIN to create a calculated table.

[hxkresl]

i am proposing a M:M relationship between 2 tables having no bridge table, so would be joining on columns that are not unique within respective tables (such as DATEKEY).

Table 1:

Datekey (not unique to row)

HoursDown

Application

Table 2:

Datekey (not unique to row)

Alert

Is that possible do DISTINCT plus CROSSJOIN or NATURALINNERJOIN to get a combined distinct set?

[Eric_Zhang]

---

@hxkresl wrote:

i am proposing a M:M relationship between 2 tables having no bridge table, so would be joining on columns that are not unique within respective tables (such as DATEKEY).

Table 1:

Datekey (not unique to row)

HoursDown

Application

Table 2:

Datekey (not unique to row)

Alert

Is that possible do DISTINCT plus CROSSJOIN or NATURALINNERJOIN to get a combined distinct set?

---

@hxkresl

Even with SQL, what would it return? Could you post any sample data and expected output?