Sum values

[diogovaz]

Hi guys,

I already searched but couldn't find an answer.

I have this 3 tables:

I want to create a Measure Field on Client Table where sum all Sales NET Value where Invoice Date is greater or equal than Today - 18 Months and Segment ID is X, Y, W, Z.

Any ideas how to do it ?

Thanks,

[diogovaz · Accepted solution]

I already solve this. 

Last Purchase Order = CALCULATE(SUMX('Client';'Sales'[NET Value Measure]);
                       FILTER('Sales';'Sales'[Date_2]>=DATE(YEAR('Sales'[Current Date]);MONTH('Sales'[Current Date])-18;DAY('Sales'[Current Date])));
                       FILTER('Reference';'Reference'[Segment ID]="A"||'Reference'[Segment ID] = "B"||'Reference'[Segment ID] = "C"||'Reference'[Segment ID] = "F"))

Hope this is helpful to other :).

Thanks,