dashboard brings total values 2 times higher than current one for previous years

[Anonymous]

I prepared a dashboard but as you see on attachment, only for previous years formula multuply total stocks by 2. but it  does not happen for current year. 

may you help me why ?

Thank you in advance

Baris 

[Bibiano_Geraldo · Accepted solution]

Hi @Anonymous ,
The issue lies in your formula not filtering by the year in addition to the month. As a result, it pulls all data for November across all years, rather than just for November of the current year.
To ensure the formula only brings values for the current month and current year, modify it as follows:

Current Backlog = 
IF(
    MONTH('Raw data'[Req. Del. Dt.]) = MONTH(TODAY()) &&
    YEAR('Raw data'[Req. Del. Dt.]) = YEAR(TODAY()),
    "Current",
    " "
)

[Anonymous]

Hello

actually problem is this formula = 

Current BAcklog = IF(MONTH('Raw data'[Req. Del. Dt.])=MONTH(TODAY()),"Current"," ")

but we are in November so formula brings all other November's value not only November-2024 .

how can I bring only current years value?

Thank you

Baris 

[daircom]

can you show us the formula?