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 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 :
4 Replies
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.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.
