Matrix with DoD (trending data) w/ 7 Day and 14 Day volume change

bolwahnn

New Member
Joined
Apr 29, 2011
Messages
40
Hey Guys,

I cant figure out how to create a visual that shows day over day data with a 7 and 14 day volume change on the most recent date. I already created a measure to calculate the 7 and 14 Day difference, but when I put it into the matrix, it does the calc for each date.....

Here's what I want (example)
Date4/14/24/34/44/54/64/7Volume Diff (6 Day)
Client A810109101215+7
Client B1512118101310-5
Client C101010101010100
Client D2015132153040+20

<tbody>
</tbody>

Here's what I"m getting (example)
Date4/14/14/24/24/34/34/44/44/54/54/64/64/7Volume Diff (6 Day)
Client A8Volume Diff (6 Day)10Volume Diff (6 Day)10Volume Diff (6 Day)9Volume Diff (6 Day)10Volume Diff (6 Day)12Volume Diff (6 Day)15+7
Client B15Volume Diff (6 Day)12Volume Diff (6 Day)11Volume Diff (6 Day)8Volume Diff (6 Day)10Volume Diff (6 Day)13Volume Diff (6 Day)10-5
Client C10Volume Diff (6 Day)10Volume Diff (6 Day)10Volume Diff (6 Day)10Volume Diff (6 Day)10Volume Diff (6 Day)10Volume Diff (6 Day)100
Client D20Volume Diff (6 Day)15Volume Diff (6 Day)13Volume Diff (6 Day)2Volume Diff (6 Day)15Volume Diff (6 Day)30Volume Diff (6 Day)40+20


<tbody>
</tbody>

* Where it says Volume Diff (6 day) my measure shows up after eachday doing the calc 6 days back ---- But I just want it on the last date..

Hope this makes sense.....Appreciate any help.

Thanks
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Well, I guess your measure is wrong. How about you post your data model relationship view and your measure.

I may not be explaining correctly.... The measure works in that it gives me the volume difference between dates, but its doing the calculation for every date. I only want the last date to provide the difference in volume. So I have Day over Day trending data and at the end, a 7 day variance from 4/1 to 4/8.

Like this
4/1/4/24/34/44/54/64/74/87 Day diff
1012131415161718+8

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>

Instead, I'm getting a 7 Day diff after every date,i.e. so 4/7 is doing the 7 day diff calc from 3/31, 4/6 is doing the calc from 3/30, and so on and so forth.

I just want the 7 day diff calc on the last reported date - Not on every date.
 
Upvote 0
Are you using Excel? If so
1. Create your pivot that shows the values you don't want.
2. click in the pivot
3. go to Analyze/Fields, Items and Sets
4. Create new set based on column items
5. Delete the individual items you don't want to see
 
Upvote 0
Are you using Excel? If so
1. Create your pivot that shows the values you don't want.
2. click in the pivot
3. go to Analyze/Fields, Items and Sets
4. Create new set based on column items
5. Delete the individual items you don't want to see

Not in Excel.... I'm trying to build this in PowerBI, not sure if its possible---- I was utilizing the Matrix visual, but it does the calc/measure on each date when I only need it at the end (on the last date published).
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top