I have this setup:
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?
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests