Forum Discussion

Icon for Helper II rank

Helper II

6 years ago

Solved

Need help in writing DAX

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

data protection

Tips and Tricks

Ashish_Mathur
6 years ago
Hi,

You may download my PBI file from here.

Hope this helps.

5 Replies

Mariusz
Community Champion
6 years ago
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.
Need help in writing DAX.pbix38 KB
- Shamsbutt
  Helper II
  6 years ago
  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.
Ashish_Mathur
Super User
6 years ago
Hi,

You may download my PBI file from here.

Hope this helps.
- Shamsbutt
  Helper II
  6 years ago
  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
    Super User
    6 years ago
    You are welcome.

Related content