topic DAX HELP TO CREATE A NEW TABLE in DAX Commands and Tips

DAX HELP TO CREATE A NEW TABLE

Istiak_Ahmed — Tue, 02 Jul 2024 20:22:54 GMT

i have this data model ,

i want to create a Newtable where i have columns dim_document [title], fact_document[id],dim_journal[name],dim_audience[description],

*can not add the dim_audince[description] with the new table*

Re: DAX HELP TO CREATE A NEW TABLE

Anonymous — Wed, 03 Jul 2024 02:29:46 GMT

Hi, Istiak_Ahmed

What fields are at play in the relationship you are describing, and can you give the data necessary to create a new table in a tabular format?

Best Regards,
Yang
Community Support Team

Re: DAX HELP TO CREATE A NEW TABLE

Istiak_Ahmed — Wed, 03 Jul 2024 03:53:27 GMT

hey, thank you for your response

FACT_DOCUMENT [DOCUMENT_ID]-------------->DIM_DOCUMENT[ID]

FACT_DOCUMENT [JOURNAL_ID]--------------> DIM_JOURNAL[ID]

DIM_JOURNAL[ID] ------------------> DIM_JOURNAL_AUDIENCE [JOURNAL_ID]

DIM_JOURNAL_AUDIENCE [AUDIENCE_ID]---------------->DIM_AUDIENCE[ID]