Forum Discussion
Create a matrix using columns with different tables
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
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
3 Replies
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 LinkedinThanks amitchandak , This helped me . You are cool 👍
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 ?