Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to 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,
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,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |