In this session we discussed about new column and new measure in power Bi.
---------------------------------------------------------------------------
Create your own measures in Power BI Desktop
---------------------------------------------------------------------------
You can create some of the most powerful data analysis solutions in Power BI Desktop by using measures. Measures help you by performing calculations on your data as you interact with your reports. This tutorial will guide you through understanding measures and creating your own basic measures in Power BI Desktop.
-----------------------
Prerequisites
----------------------
This tutorial is intended for Power BI users already familiar with using Power BI Desktop to create more advanced models. You should already be familiar with using Get Data and Query Editor to import data, working with multiple related tables, and adding fields to the Report Canvas. If you’re new to Power BI Desktop, be sure to check out Getting Started with Power BI Desktop.
Download the Contoso Sales Sample for Power BI Desktop file, which includes online sales data from the fictitious company Contoso, Inc. This data was imported from a database, so you won’t be able to connect to the datasource or view it in Query Editor. Extract the file on your own computer, and then open it in Power BI Desktop.
----------------------------------
Understand measures
----------------------------------
Measures are most often created for you automatically. In the Contoso Sales Sample file, select the checkbox next to the SalesAmount field in the Sales table in the Fields well, or drag SalesAmount onto the report canvas. A new column chart visualization appears, showing the sum total of all values in the SalesAmount column of the Sales table.
Any field that appears in the Fields well with a sigma icon sigma icon is numeric, and its values can be aggregated. Rather than showing a table with all two million rows of SalesAmount values, Power BI Desktop detected a numeric datatype and automatically created and calculated a measure to aggregate the data. Sum is the default aggregation for a numeric datatype, but you can easily apply different aggregations like average or count. Understanding aggregations is fundamental to understanding measures, because every measure performs some type of aggregation.
To change the chart aggregation to average, in the Value area of the Visualizations pane, click the down arrow next to SalesAmount and select Average. The visualization changes to an average of all sales values in the SalesAmount field.
Thanks
Srinivas
New Column,Measure in Power BI | Power BI Training | PowerBI Guru camera iphone 8 plus apk | |
| 3 Likes | 3 Dislikes |
| 1,003 views views | 1.14K followers |
| Science & Technology | Upload TimePublished on 19 Apr 2018 |
Không có nhận xét nào:
Đăng nhận xét