Create a matrix using columns with different tables

[Anonymous]

Hi 

I am new in creating matrix. Stuck with this. Please give me some suggestion to do it so that I can implement it in my work. Thanks in Advance. Your suggestions will be helpful.

I have 2 tables, as shown in Fig below
Table1

Table2

 
I need to create a table or matrix as shown in below Image.
matrix

If you get me some examples or tips would be great. Thanks

[amitchandak · Accepted solution]

Join both date with a date or month dimension and take the month from there. And then put the matrix. In matrix table, there is an option under format. "Show on row" This will move you measure to row. On column put Month.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

Hi @amitchandak ,

Sorry, I am again stuck with adding YTD columns in the matrix. If you can please help me on this that would be great.

In the previous message I have not added date for 2018. But how can we add the YTD2018 and YTD2019 for all the 3 quantities ?

[Anonymous]

Thanks @amitchandak , This helped me . You are cool 👍