Need help in writing DAX

[Shamsbutt]

I have input(Base Data) and output (Output Desired) as shown on attached image,

that i need to show in power bi metrix as it is showing in image.

Please help!

Source File

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Shamsbutt]

Thanks @Ashish_Mathur , this is what i want.

I have also tried though some dax download my work Link,but yours output is 100% fit to me.

output

[Ashish_Mathur]

You are welcome.

[Mariusz]

Hi @Shamsbutt 

Please see the attached file with a solution.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Shamsbutt]

@Mariusz  Thanks,

You are near to the solution but i want exact same output in form of matrix's Rows and Columns, as shown in below image.