Forum Discussion
googlogmob
Advocate II
Advocate IIINNER 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
Community Champion
Community ChampionUse 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