Forum Discussion

HARMKE964's avatar
HARMKE964
Frequent Visitor
8 years ago

Previous Quarter No Result

All,   I want to know my previous quarter dollar ammount shipped.  I am having an issue due to when I calculate previous quarter, it does not show anything.  This is what I came up with thus far: ...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi HARMKE964,

 

Please share a dummy sample.

1. Make sure the measure has proper context.

2. What's the formula of [TOTAL DOLLAR AMMOUNT SHIPPED]?

3. What's the connection mode? Import or Direct query.

 

Best Regards,

Dale

HARMKE964's avatar
HARMKE964
Frequent Visitor
8 years ago

Ok, so I got it now, you all need more information (understood).  This is how my model looks like so you all can see the relationships:

 

 

The formula I am using for "TOTAL DOLLAR AMMOUNT SHIP" is based of:

 

Step 1

=CALCULATE(AVERAGEX(RELATEDTABLE('QUERY OEORDER DETAIL'),'QUERY OEORDER DETAIL'[UNIT_PRICE]))  :

I am doing this average so I can bring the price of parts from 'QUERY ORDER DETAIL' in to 'QUERY ORDER SHIPPING'

 

Step 2:

=CALCULATE(SUM([AVG UNIT PRICE DETAIL])*SUM([QTY_SHIPPED])) :

Then I create a colunm that will display the dollar ammount shipped

 

Step 3:

TOTAL DOLLAR AMMOUNT SHIPPED:=SUM([AVG USD SHIPPED])  :

A simple SUM at the bottom of my column created at step two

 

 

Step 4:

 

I tried the formula that I already posted at the begining of this post. I hope this helps.

 

Thanks,