Forum Discussion
Solved
TSQL GroupBy with Having
Hi there, How do I convert TSQL to DAX Select CustomerID From Customer Where CreatedDT >= 1/1/2022 And CreatedDT <= 1/31/2022 Group by CustomerID Having Max(NewCustomerID) = 1 ---------- Thi...
Table = CALCULATETABLE( FILTER( DISTINCT( Customer[CustomerID] ), CALCULATE( MAX( Customer[NewCustomerID] ) ) = 1 ), EOMONTH( Customer[CreatedDT], 0 ) = DATE( 2022, 1, 31 ) )
Table =
CALCULATETABLE(
FILTER(
DISTINCT( Customer[CustomerID] ),
CALCULATE( MAX( Customer[NewCustomerID] ) ) = 1
),
EOMONTH( Customer[CreatedDT], 0 ) = DATE( 2022, 1, 31 )
)
You are Super Duper - It works
Thanks,
Oded Dror
One more question how do I display this value in a matrix for each row?