Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.