Forum Discussion
Solved
INNER JOIN
Please, help to make this T-SQL in DAX select distinct
cte.[ID] from cte
inner join cte cte2 on cte.[ID]=cte2.[ID]
and cte2.[Group] in ('NEW';'OLD')
and cte2.[Date] < MIN('Calendar'[D...
Use CALCULATETABLE or other function like SUMMARIZE to calculate two separate VAR's. Use NATURALINNERJOIN to do a join.
https://msdn.microsoft.com/en-us/library/dn802543.aspx
Greg_Deckler, Thanks
This works
Povt =
VAR cte = CALCULATETABLE(
VALUES('cte'[ID]);
FILTER('cte';'cte'[Group]="Povt");
USERELATIONSHIP('Calendar'[Date];'cte'[Date]))
VAR cte2 = CALCULATETABLE(
VALUES('cte'[ID]);
ALL('Calendar);
FILTER('cte';'cte'[Group]IN{"NEW";"OLD"}
&& 'cte'[Date] < MIN('Calendar'[Date])
&& DATEADD('cte'[Date];91;DAY) > MAX('Calendar'[Date]));
USERELATIONSHIP('Calendar'[Date];'cte'[Date]))
VAR joined = NATURALINNERJOIN(cte;cte2)
VAR result = COUNTROWS(joined)
RETURN result
Sweet!