powerbi_newb
New Member
- Joined
- Mar 19, 2017
- Messages
- 3
Hello!
I am trying to calculate the variance of each shipment base on their corresponding dates. I have been browsing tutorials and several forums threads but to no afford, I still can't figure out the right measures/formula for the following data sets. And would like to know the total % of each shipment type base on there date.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Shipment[/TD]
[TD]Date[/TD]
[TD]JOB ID[/TD]
[/TR]
[TR]
[TD]Held for Pickup[/TD]
[TD]03/02/2017[/TD]
[TD]35112[/TD]
[/TR]
[TR]
[TD]Delivered[/TD]
[TD]03/03/2017[/TD]
[TD]35554[/TD]
[/TR]
[TR]
[TD]Picked up[/TD]
[TD]03/01/2017[/TD]
[TD]35224[/TD]
[/TR]
[TR]
[TD]On Delivery[/TD]
[TD]03/02/2017[/TD]
[TD]35243[/TD]
[/TR]
[TR]
[TD]Held for Pickup[/TD]
[TD]03/01/2017[/TD]
[TD]35617[/TD]
[/TR]
[TR]
[TD]Delivered[/TD]
[TD]03/03/2017[/TD]
[TD]35612[/TD]
[/TR]
[TR]
[TD]Picked up[/TD]
[TD]03/01/2017[/TD]
[TD]35251[/TD]
[/TR]
[TR]
[TD]On Delivery[/TD]
[TD]03/02/2017[/TD]
[TD]35124[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 54px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]03/01/2017[/TD]
[/TR]
</tbody>[/TABLE]
Here is an image for the graph of my power bi. I want to input both variance and % total of each shipment as my line (trend values).
Any help would be greatly appreciated.
I am trying to calculate the variance of each shipment base on their corresponding dates. I have been browsing tutorials and several forums threads but to no afford, I still can't figure out the right measures/formula for the following data sets. And would like to know the total % of each shipment type base on there date.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Shipment[/TD]
[TD]Date[/TD]
[TD]JOB ID[/TD]
[/TR]
[TR]
[TD]Held for Pickup[/TD]
[TD]03/02/2017[/TD]
[TD]35112[/TD]
[/TR]
[TR]
[TD]Delivered[/TD]
[TD]03/03/2017[/TD]
[TD]35554[/TD]
[/TR]
[TR]
[TD]Picked up[/TD]
[TD]03/01/2017[/TD]
[TD]35224[/TD]
[/TR]
[TR]
[TD]On Delivery[/TD]
[TD]03/02/2017[/TD]
[TD]35243[/TD]
[/TR]
[TR]
[TD]Held for Pickup[/TD]
[TD]03/01/2017[/TD]
[TD]35617[/TD]
[/TR]
[TR]
[TD]Delivered[/TD]
[TD]03/03/2017[/TD]
[TD]35612[/TD]
[/TR]
[TR]
[TD]Picked up[/TD]
[TD]03/01/2017[/TD]
[TD]35251[/TD]
[/TR]
[TR]
[TD]On Delivery[/TD]
[TD]03/02/2017[/TD]
[TD]35124[/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 54px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]03/01/2017[/TD]
[/TR]
</tbody>[/TABLE]
Here is an image for the graph of my power bi. I want to input both variance and % total of each shipment as my line (trend values).
Any help would be greatly appreciated.