Power Pivot Measure SUMIFS

Question

I have this setup:

date                          cost
22 march 2018                  100
10 january 2018                20
15 march 2019                  150
12 january 2019                133

I don't know in advance, which cost, dates or how many rows I'll have.

Need a measure that takes this criteria into consideration: - IF the month is the same as the max month, then, sum the cost of that month until the max day.

The cost for january 2018 would display 20 and all the remaining months would remain equal except for MARCH 2018, because it only sums cost until the max day of the max month (12).

Is this possible to achieve with a measure?

https://i.imgur.com/sElSBIS.png

Answer 1

As far as I understand you are speaking about a year to date calculation :

you can therefore use this formula :

TOTALYTD(Expression;Date)

All Explaination can be found here