Combining Two DAX Expression Tables into One... Uniquely?

[BrianRiggin]

Sorry, I'm sure there is a word or term to describe how I'm trying to combine/merge/??? them other than "uniquely", but I couldn't think of it.

I need to build a custom DAX table from two other DAX table expressions (one using FILTER, the other DISTINCT from source tables).  How do??

DAX Expression 1 - DISTINCT(NameTable[Name])                     

a

b

DAX Expression 2 -  FILTER(CALENDARAUTO(),[Date]>=[StartDateMeasure]&&[Date]<=[EndDateMeasure]&&WEEKDAY([Date])=3)

1

2

3

*Note:  The measures are fixed dates.  I'm essentially getting all the Tuesdays between two dates

Custom DAX Table

1	a
2	a
3	a
1	b
2	b
3	b

[mangaus1111 · Accepted solution]

Hi @BrianRiggin ,

you can use CROSSJOIN function.

CROSSJOIN ('Table1','Table2')

https://dax.guide/crossjoin/

If this post helps, please mark it as solution!!!

[BrianRiggin]

That was perfect!  Thanks!  Also, I guess the term I was looking for was a "Cartesian Product" rather than "...uniquely".  So I learned two things!