Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎03-20-2017
Accepted Solution

Variance of Shipment type ranging from different Dates

Hello!

I am trying to calculate the variance of each tracking number base on their corresponding dates. I have been browsing tutorials and forums threads but to no afford, I still can't figure out the right measures/formula for the following data sets. I would like to know as well, how do I measure the % (percentage of each tracking number base on the shipment status on a particular day). 

Shared Axis:
Dates
Column Series:
Shipment Status
Column Value:
Tracking Numbers
Line Values:
Variance, this is what I really need a help for.

This is data sets that I have.

 

Inked2017-03-20_1734_LI.jpg


Sorry that I have to cover the whole tracking number.


Each tracking number is unique.
In Status_Dec(Shipment Status) there are at least 15 distinct value. In transit, On Delivery, Delivered, Exception and so on...

This is an image of my current power bi chart. 
 

 

2017-03-20_1726.png

  

Any help would be greatly appreciated.


Accepted Solutions
Frequent Visitor
Posts: 2
Registered: ‎03-20-2017

Re: Variance of Shipment type ranging from different Dates

An update to the post. 

I have already solved it. The computation was fairly simple, and had been thinking to hard to solve it, but the calculation was straight forward I just miss it, I guess.

Variace = Sum - Calculate((Sum,Previousday))

Anyway thank you!

View solution in original post


All Replies
Frequent Visitor
Posts: 2
Registered: ‎03-20-2017

Re: Variance of Shipment type ranging from different Dates

An update to the post. 

I have already solved it. The computation was fairly simple, and had been thinking to hard to solve it, but the calculation was straight forward I just miss it, I guess.

Variace = Sum - Calculate((Sum,Previousday))

Anyway thank you!