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
I need to calculate sales per product from Expected selling start date and 4 month ahead.
How do I do that?
I have tried this measure, but it gives me an error.
Solved! Go to Solution.
I have changed the measure to this:
@LotteLaugesen , Try this
CALCULATE(CALCULATE(SUM('Fact Sales'[Volume]),
USERELATIONSHIP(Dim_Calendar[Date],'New Products'[Expected Selling Start Date])),
DATESINPERIOD(Dim_Calendar[Date ],Min(Dim_Calendar[Date])+1,4,MONTH) )
I have changed the measure to this:
@LotteLaugesen , Try like
Volume 4 Month =
CALCULATE(SUM('Fact Sales'[Volume]),
USERELATIONSHIP(Dim_Calendar[Date],'New Products'[Expected Selling Start Date]),
DATESINPERIOD(Dim_Calendar[Date ],Min(Dim_Calendar[Date])+1,4,MONTH) )
Thank you for helping, but the measure shows a blank result.
@LotteLaugesen , not able to relate your comments with the with data, can you elaborate
For each product in New Products file I want sum of Volume from Fact Sales for 4 month after Expected selling start date. I only want to list the products in the New Products file, not any other product sold.
For Product100 it should sum volume from Fact Sales from 1st of January to end of 1st of April.
For Product200 it should sum volume from Fact Sales from 2nd of February to end 2nd of May
And so on.. Does this make it more clear?
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |