cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shamsbutt
Helper II
Helper II

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!

 

 

Untitled.png

 

Source File

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User III
Super User III

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User III
Super User III

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

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

Untitled.png

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Mariusz
Super User II
Super User II

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.

@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.

 

Untitled.png

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors