Forum Discussion
Sales Territory as a Dimension - DAX Help! (Nested IF statement?)
My company operates across the U.S. I would like to align cities with a sales territory so that I can see performance dimensiolanized a different way. In my dataset I have the cities listed, but...
Hi Anonymous
Why don't you just ...
1.- Create a table in Excel with the list if cities and their classification.2.- Import through the Query Editor that table to Power BI.
3.- Create a relationship between the cities table you just created and the one you have the data in.
4.- Apply the visual you need.
Hope That Helps
Vicente
vcastello
Resolver III
Resolver IIIHi Anonymous
Why don't you just ...
1.- Create a table in Excel with the list if cities and their classification.
2.- Import through the Query Editor that table to Power BI.
3.- Create a relationship between the cities table you just created and the one you have the data in.
4.- Apply the visual you need.
Hope That Helps
Vicente