dax notes

1. the relationship may exist between data tables.
2. Power BI Desktop is usually applied in building complicated queries,advanced models and compelling reports.
3. intalling Power BI Deskop can be installed from Microsoft Store,but it is recommand to download its installer from the Microsoft Download Center.
4. The infrastructure of Power BI consists of reports,workbooks,semantic models,dataflows,dashboards and applications.
5. the workspace which only used for personal task and my workspace are the container of PowerBI.the report is a visual object .
6. PowerBi can connect to some data sources and write complex query statements to generate data model . the Power Query provides a set of functions for transforming the data to meet various requirements.regular modifications include renaming column name or table name,remove row or column and change the type of data.
7. union query means that one table join another table by certain column to generate new table through merging or appending.

• to merge query

if you click any cell of column6, the bottom of PowerBi interface will show corresponding item in 支出部门 table.

of course,you may define what column will be showed through clicking the expansion icon of column header .


selecting only the id ,so that id will be displayed on the far right.

references

1. https://learn.microsoft.com/