Forum Discussion
Solved
Create table visualization using two different columns from the semantic model data
Hello, I am using Power BI Service to build a table visualization A based on existing semantic model, whcih has columns of "Orig_City", "Dest_City", "Sales", "Date" Is it possible to build the t...
Hey buck1327 ,
In Power BI Service, you can go to the EDIT option and then go to Data Model. And then, right click on the Model and select Calculated Table. Then, you can put in the appropriate DAX to do what you want.
You can tweak this as you need, but this is a good first pass for you DAX:
Combined_City_Sales =
UNION (
SELECTCOLUMNS (
YourTableName,
"City", YourTableName[Orig_City],
"Total_Sales", YourTableName[Sales]
),
SELECTCOLUMNS (
YourTableName,
"City", YourTableName[Dest_City],
"Total_Sales", YourTableName[Sales]
)
)As for Question 2, I think that you will be able to link or otherwise refer to the fields that you want.
Hello,
To clarify the first part, is this what you're looking for? (Mockup in Excel)