SUM expenses current month until yesterday

[DaGi07]

Hello guys,

i'd like to sum the value "importo" from the table "spese" of current month BUT until yesterday

example:

Date                  Importo

01/01/2023.         3

02/01/2023        3

03/01/2023        2

04/01/2023.       5

Result:   8 because is the sum from 01/01/2023 to 03/01/2023

How can i integrate this formula:

SUM(
SELECT(spese[importo],
AND(MONTH([DATA]) = MONTH(TODAY()), YEAR([DATA])=YEAR(TODAY())
))

Thanks guys!!

[Suvrutt_Gurjar · Accepted solution]

Please try 

SUM(
SELECT(spese[importo],
AND(MONTH([DATA]) = MONTH(TODAY()), YEAR([DATA])=YEAR(TODAY()), DAY([DATA])< DAY(TODAY()))
))

You may first want to create a slice called Current Month spece for the current month dates with an expression something like below

AND(MONTH([DATA]) = MONTH(TODAY()), YEAR([DATA])=YEAR(TODAY()), DAY([DATA])< DAY(TODAY()))

Then the sum expression can be simply SUM( Current Month spece[importo]))

[DaGi07]

@Suvrutt_Gurjar thanks to you finally i completed the formula that consent to create a daily saving according to the monthly amount that you want save!

I post here the expression that consent to do this in case could be useful for someone else