Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have the following 2 tables in a PBI Report Server, which uses DirectQuery and are linked by well_id and id:
I need to add a column in the wells table, with the AliasName which AliasNameTypeID = 'opendes:reference-data--AliasNameType:WellCommonName:'
Basically move the AliasName column to the wells table in the following query (but using DAX)
Any Ideas? Thanks in advance!
@santiago_ortiz , across-table operations are not supported other than related in (One side to many sides) in a calculated column
You can create a new measure
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.