Posts by mxix • 136 points
3 posts
-
0
votes1
answer58
viewsA: Lowest value (DAX variables)
It would be possible through MINX. M_Teste = var v1 = 10 var v2 = 8 var v3 = 11 var v4 = 9 return MINX({v1,v2,v3,v4},[Value])
-
1
votes3
answers1305
viewsA: List records that are in a table and those that are not in the same table
I will assume that a user who has entered 01 or entered 02 on the selected date has clocked in. DECLARE @DATA DATE; SET @DATA = '2016-05-09'; select nome, CASE WHEN Picou > 0 then 'Sim' else…
-
1
votes1
answer78
viewsA: Add items from table 1 and bring in indexed Rows from table 2
SELECT tabela2.nome, tabela2.codigo, SUM(tabela1.itens) FROM tabela1, tabela2 WHERE tabela1.codigo_tabela2 = tabela2.codigo AND tabela1.ativo = b'1' AND …