Forum Discussion
Russ99
Helper I
Helper Idax formula
Hi Community, I need some help writing a formula that will calculate when a customer is meant to pay for an item. The date they are meant to pay depends on 2 things, how many days their payment t...
Hi Russ99 ,
My sample is as below.
Table1:
Table2:
Relationship:
Measure:
date customer meant to pay = VAR _Payment_terms = SUM ( Table2[payment terms] ) VAR _net_or_eom = MAX ( Table2[net or eom] ) VAR _Transaction_Date = MAX ( Table1[Transaction Date] ) RETURN IF ( _net_or_eom = "net", _Transaction_Date + _Payment_terms, EOMONTH ( _Transaction_Date, 0 ) + _Payment_terms )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Russ99 ,
My sample is as below.
Table1:
Table2:
Relationship:
Measure:
date customer meant to pay =
VAR _Payment_terms =
SUM ( Table2[payment terms] )
VAR _net_or_eom =
MAX ( Table2[net or eom] )
VAR _Transaction_Date =
MAX ( Table1[Transaction Date] )
RETURN
IF (
_net_or_eom = "net",
_Transaction_Date + _Payment_terms,
EOMONTH ( _Transaction_Date, 0 ) + _Payment_terms
)Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Russ99Helper I
Helper Ithis has worked really well for a lot of my data so thanks so much for that. however the measure customer meant to pay is throwing out some results in the year 2117 and some in the year 1900, do you know why this could be?