Forum Discussion
[DAX Measure] Referencing another table to add a calculated value
Hello All, I am currently stuck with this use case below and would greatly appreciate any input. Building a POC off of Azure Analysis Services so I have limitations around creating calcualted...
Hello!
I believe I found a reliable DAX formula for this. First, I assume that the Parent Table only contains each Id once. Therefore, we must first start by creating a one-to-many relationship from the Parent Table to the Origin Table by linking Ids.
From there, we can use the following DAX formulas to create custom columns inside the Origin Table:
New X = RELATED('Parent Table'[Origin X]) + [Start X]New Y = RELATED('Parent Table'[Origin Y]) + [Start Y]Hope this helps!
Sean, you are not able to add a calculated column, because this model is leveraging AAS. We are only able to create measures.