Help creating custom table with measures

[thampton]

I have a model with a variety of tables connected via different relationships. Right now i have these combined into a matrix with calculated measures serving as the columns. I would like to store these values in a separate table. How would i do this?

It would look like:

Column 1               Column 2  (DATE from date table)     Column 3 (Measure)

Tom                                               1/1/2019                                         2

John                                              1/1/2019                                         4

Jane                                               1/1/2019                                        5

[darentengdrake]

Hi @thampton ,

You can try creating a table using DAX. Use ADDCOLUMN function to add the columns you want for each table as well as create a measure in it.

[thampton]

@darentengdrake  Thanks for the quick response! Am i able to create this table using columns from multiple tables? So it would have a value from table 1 , table 2, etc...?

[v-piga-msft]

Hi @thampton ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[darentengdrake · Accepted solution]

Hi @thampton 

I think you could.

Refer to this article and use one of their examples to craft your DAX.

https://docs.microsoft.com/en-us/dax/addcolumns-function-dax