Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
powerbi_newbie
New Member

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.

1 ACCEPTED SOLUTION
powerbi_newbie
New Member

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

1 REPLY 1
powerbi_newbie
New Member

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!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors