Date from another table

[Anonymous]

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 table I have the date and in the second the details of my invoices.

I linked the two tables in the architecture on basis of an ID and now, I'm trying to make a measure to :

Calculate the sum of the amount of my lines for the invoices having a date > to another calculated date.

I tried many possibilites but I don't reach my goal.

Example : 

Prev_CA= calculate(sum(ImputationMultiple[Amount]);ImputationMultiple[Account]="700000";ImputationMultiple[IDTable]="33";DATESBETWEEN(Invoices[Date_Invoice];[DateClot+1];ENDOFYEAR(Invoices[Date_Invoice])))

Does someone can help me please?

Thanks a lot and have a nice day

[v-chuncz-msft]

@Anonymous 

You may use RELATED to add a calculated column first.

[amitchandak]

@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

[Anonymous]

@amitchandak 

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.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.