This question is specific for cash flow purposes. For Accounts Payables I have 2 dates for cash flow 1) when I expense items (like rent) so Posting Date and 2) when I actually pay the rent Invoice Date. That being said from an accounting perspective I am recognizing cash at 2 different points 1) when I expense that month and 2) when I actually pay. I am trying to figure out how to netout the cash flow/AP balance for each month based on the 2 different dates. Any suggestions?
Measure: Accounts Payables
Dates: Posting Date, Payment Date
You can pivot the data as
Posting Date,Accounts Payables
Payment Date,Accounts Payables
if you want to subtract them then 1 of them you can take -1 * Accounts Payables.
For union you can use same source twice and union them in Tableau.