Power Pivot help on creating calculated columns

[Pavan.Sada.PS]

Hello Dears,

I am a noob toward data modeling and power pivot features. Could you help me solving my quiries. Attached file has my questions and expected answers. please do let me know how to solve it.

[teylyn]

Please put your question into the post. Don't force people to download a file just so they can figure out what you're asking. Please don't make it harder to help you than absolutely necessary.