Create a Matrix between two unrelated tables

Question

Hello,&nbsp;I have a column in a table that contains the row headers I need for a matrix.&nbsp; However, for my columns, I need to have the numbers 1-30 (so, 30 columns) that correspond to a month.&nbsp; This is just a generalization for each month so it doesn't need to be an actual existing month.&nbsp; Anyway, I need those numbers as the column headers but they don't exist anywhere in my data (other than creating a table with GENERATESERIES to get my 1-30 values. Then the cells in the matrix would contain a formula to act as a "per day" value.&nbsp; Here's an oversimplification:&nbsp;Table 1 exists and it includes that column that contains the values I need for my Matrix row headers.&nbsp; I need to be able to create the series of 1-30 columns and also write the DAX for values in the cells.&nbsp; Since there are 30 days, each cell would divide the value by 30.&nbsp;Hopefully that all makes sense!&nbsp;Thank you!

danextian · Accepted Answer

Hi JLambs20 ,You can create a measure from two unrelated tables in DAX.&nbsp; You can have something likeMyMeasure =
DIVIDE ( SUM ( Table1[Column] ), SELECTEDVALUE ( DaysTable[Day] ) )&nbsp;The matrix will return an error if you put in the two fields from unrelated first but should be fine after adding the measure. If this doesn't work, please post&nbsp; a sample data that we can copy-paste.

Forum Discussion

Create a Matrix between two unrelated tables

2 Replies

Related content

Creating a Measure Between Two Unrelated Tables

Combining Data From Unrelated Tables To Create Charts

Creating a Calculated Column Between Two Unrelated Tables

Creating ICMs via Activator

Creating relationships