Forum Discussion
Formula com filtro de data
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
Hi Anonymous ,
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.
2 Replies
V-lianl-msftCommunity Support
Hi Anonymous ,
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.