Posts by mxix • 136 points

• 0

  votes

  1

  answer

  58

  views

  A: 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])

  powerbi dax

  answered 4 years ago mxix 136

• 1

  votes

  3

  answers

  1305

  views

  A: 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…

  mysql sql

  answered 8 years, 6 months ago mxix 136

• 1

  votes

  1

  answer

  78

  views

  A: 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 …

  sql postgresql

  answered 10 years, 1 month ago mxix 136