I am trying to duplicate values for dates when all I have is the start date. It's a SUM of all relevant volume but not cumulative since I don't want to add from the prior month.
I receive a row value showing weekly quantity processed by start date. I also have a standard date table with every date in the range.
Customer Volume Start Date
A 20,000 5/1/2017
B 10,000 5/1/2017
A 5,000 8/1/2017
C 10,000 10/1/2017
I would like the result to be a pivot table showing the total volume for each month
<tbody>
</tbody>
How can I write a DAX measure to provide the numbers? I would also like to have other derived measures (e.g. cost per unit) based on the volume totals.
I receive a row value showing weekly quantity processed by start date. I also have a standard date table with every date in the range.
Customer Volume Start Date
A 20,000 5/1/2017
B 10,000 5/1/2017
A 5,000 8/1/2017
C 10,000 10/1/2017
I would like the result to be a pivot table showing the total volume for each month
2017 | 2018 | |
Jan | 45,000 | |
Feb | 45,000 | |
Mar | 45,000 | |
Apr | 45,000 | |
May | 30,000 | 45,000 |
Jun | 30,000 | etc |
Jul | 30,000 | |
Aug | 35,000 | |
Sep | 35,000 | |
Oct | 45,000 | |
Nov | 45,000 | |
Dec | 45,000 |
<tbody>
</tbody>
How can I write a DAX measure to provide the numbers? I would also like to have other derived measures (e.g. cost per unit) based on the volume totals.