Forum Discussion
Combining Two DAX Expression Tables into One... Uniquely?
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 |
Hi BrianRiggin ,
you can use CROSSJOIN function.
CROSSJOIN ('Table1','Table2')
If this post helps, please mark it as solution!!!
2 Replies
- mangaus1111
Solution Sage
Hi BrianRiggin ,
you can use CROSSJOIN function.
CROSSJOIN ('Table1','Table2')
If this post helps, please mark it as solution!!!
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!
