Total Sales for the current month

[Thiagops]

Good morning,
In the formula below, the intention is to add all the sales of the current month, however the result is not correct. It should be 291,241.28, but it's only pulling 114.41k

Total GERAL de vendas do mes atual =

CALCULATE(

    SUM(NF_SAIDA[NS_TOTAL_NOTA]),

    NF_SAIDA[NS_DATA_EMISSAO] > EOMONTH(TODAY(),-1),

    ALL(NF_SAIDA)

)

Can anyone help me find the error?

[tamerj1 · Accepted solution]

HI @Thiagops 

It should work. Check:
1. The data type of the [NS_TOTAL_NOTA] column and confirm it it is DateTime data type.

2. Check for blanks in the column.

3. Check the date regional format (dd/mm/yyyy or mm/dd/yyy)