Forum Discussion
Date from another table
Hi everybody, Certainly a stupid question for most of you but I really do not find a way to handle this. 2 tables -> 1° Invoices ; 2° Invoices_lines (ImputationMultiple) In the first tab...
Anonymous , Join your Invoice date with a date table and try like
Prev_CA= calculate(sum(ImputationMultiple[Amount]);ImputationMultiple[Account]="700000";ImputationMultiple[IDTable]="33";
DATESBETWEEN(Date[Date];[DateClot+1];ENDOFYEAR(Date[Date])))
Not sure what you wanted in [DateClot+1], correct that
Thanks for your proposal but doesn't work.
DateClot+1 is the other date from which I would like to start the filter of my dates...
The idea is to take the real sales amount until "DateClot" and to calculate the amount like I said from "DateClot"+1 day.