SUMX problem

[didijaba]

HI, I have related tables and I need to make calculated column that shows on how many days was some rate applied. There are two tables, one that shows customers and in what period they used service (days between OPENING_DATE and CLOSE_DATE) and second table that shows on what services what rate was applied (days between DATE_STAMP and DATE_STAMP_NEXT). This is formula I wanted to use in Rate table, and this is file.
https://drive.google.com/file/d/0B-ucSPLqBsATTFMtMmxyZC0zMjA/view?usp=sharing

=SUMX (
FILTER(
START_POINT;
START_POINT[HELP_COL_2]='QUERY_tbl_LOG'[HELP_COL_1] &&
START_POINT[OPENING_DATE]< 'QUERY_tbl_LOG'[NEXT_DATE_STAMP] );
INT ( 1
+ IF (
 ( 'QUERY_tbl_LOG'[NEXT_DATE_STAMP]) <= START_POINT[CLOSE_DATE]  ;
( 'QUERY_tbl_LOG'[NEXT_DATE_STAMP] );
START_POINT[CLOSE_DATE]
)
- IF (
( 'QUERY_tbl_LOG'[DATE_STAMP] ) >=START_POINT[OPENING_DATE] && ( 'QUERY_tbl_LOG'[DATE_STAMP] )< START_POINT[CLOSE_DATE];
( 'QUERY_tbl_LOG'[DATE_STAMP] );
START_POINT[OPENING_DATE]
)
)
)

 

[didijaba]

SOLVED. I had error in HELP_COL_2 formula and I have changed full formula to

=SUMX (
FILTER(
START_POINT;
(START_POINT[HELP_COL_2])='QUERY_tbl_LOG'[HELP_COL_1] &&
START_POINT[RESERVATION_DATE]>='QUERY_tbl_LOG'[DATE_STAMP] &&
START_POINT[RESERVATION_DATE]<'QUERY_tbl_LOG'[NEXT_DATE_STAMP])
;
INT ( 1
+ IF (MONTH(START_POINT[CLOSE_DATE])=MONTH([OPENING_DATE]);
 START_POINT[CLOSE_DATE]  ;
 EOMONTH(START_POINT[OPENING_DATE];0))
-START_POINT[OPENING_DATE]))