Forum Discussion

Jobi10's avatar
Jobi10
Regular Visitor
4 years ago

Calculate value per month based on different value per day

I want to show in a matrix the value per month of all projects during a selected period. This isn't very difficult, but I'm stuck with the following:   A project can have a different value during t...
Need Help
Jobi10's avatar
Jobi10
Regular Visitor
4 years ago

Hi Amitchndak, thanks for your help. It works fine for the total value per Month without the rebates. However, with this solution it doesn't understand whitch part of a certain "Rebates" rule is active. In this case for the month of January of project 1: I expect to show a value of € 200 in the Value_month_rebates column. 
I used this Measure:

1. Day by Month rebates = CALCULATE(countx(SUMMARIZE(filter(CROSSJOIN('Rebates','Date'),'Date'[Date] >= 'Rebates'[Start_rebates] && 'Date'[Date] <= 'Rebates'[End_rebates]),'Project[ProjectID],'Date'[Date]),'Date'[Date]))

2. Value_Month_rebates = [Day by Month rebates] * SELECTEDVALUE(Rebates[DayRebates])

 

The only relation between tables is the relation Project [ProjectId]  1 ---- * Rebates [ProjectId]
There are no relations to the calender table.

 

Do you have any other solutions to show the total rebates value per month combined with the total projectvalue?