Power Pivot challenging IF Measure

Anything related to PowerPivot and DAX Formuale
gchain
Posts: 1
Joined: Mon Sep 02, 2019 1:39 pm

Power Pivot challenging IF Measure

Postby gchain » Mon Sep 02, 2019 1:42 pm

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).

Basically, the year before will be affected, while the current year is always the original value.

Is this possible to achieve with a measure?


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

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest