Create New Table from Existing SQL Server Many-to-Many Relationship

[Anonymous]

I have an existing many-to-many relationship in SQL Server that has been pulled into Power BI.  I would like to create a 'dynamic' table in PowerBI using fields from each table from both sides of the relationship.  I can do this in a visualization no problem, but I need to also add some conditional fields so I'm thinking a new table is the way to go?  Any ideas would be fantastic.

[lbendlin]

Let the data model do the work for you. (Also known as "Don't fight the API")

Define what you mean by "conditional fields"  - should these be measures or calculated columns?

[Anonymous]

Sorry for the confusion.  Calculated columns.

[lbendlin]

If it is a calculated column then you can also think about implementing it in either Power Query or your SQL server source.  DAX is always the last resort for calculated columns.