Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :
@Anonymous
You may use RELATED to add a calculated column first.
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |