You are using Dynamics 365 Sales.
You need to create a Power BI report that includes customer office locations. The City and State columns
must be combined to form one column on the report.
What should you do?
Use Power Query Editor to merge columns.
Import the data.
Export data to Microsoft Excel.
Create a view.
Submit