Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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?
Sorry for the confusion. Calculated columns.
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.