Formula com filtro de data

[lorran]

Solicito ajuda para identificar a forma correta de inserir o valor de uma data em DAX 

calc = CALCULATE(DISTINCTCOUNT(historico[CHAPA]),historico[NOVASITUACAO] <> "D", historico[DATAMUDANCA]= 1976-10-19 )

neste caso o filtro da data não trás resultado correto

[V-lianl-msft · Accepted solution]

Hi @lorran ,

Please try:

calc = CALCULATE(DISTINCTCOUNT(historico[CHAPA]),FILTER(historico,historico[NOVASITUACAO] <> "D"&& historico[DATAMUDANCA]= DATE(1976,10,19) ))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V-lianl-msft · Accepted solution]

Hi @lorran ,

Please try:

calc = CALCULATE(DISTINCTCOUNT(historico[CHAPA]),FILTER(historico,historico[NOVASITUACAO] <> "D"&& historico[DATAMUDANCA]= DATE(1976,10,19) ))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lorran · Accepted solution]

Bom dia, 

Deu certo, muito obrigado pelo auxilio.