Forum Discussion

Solution Sage

9 years ago

Solved

most frequently using queries to organize data for visualization

I am new to this Power BI. My Management asked me work on PBI Reports. I have referred few Community Videos on Youtube and played with some sample data. I can say, this is a Most Power Tool. I ha...

Need Help

v-sihou-msft
9 years ago
rocky09

When retriveing data, you can just use T-SQL query to get the data. Power BI will generate Power Query which you can edit it in Query Editor (Advance Editor). For Power Query (M language), please see: Power Query (informally known as "M") Formula reference.

For retrieved dataset, you can use DAX to add measure and calculated column for your calculation. For DAX tutorials, please see: DAX basics in Power BI Desktop

QuickStart: Learn DAX Basics in 30 Minutes

SQL Server DAX Tutorial Overview

Regards,

v-sihou-msft

Microsoft Employee

9 years ago

rocky09

When retriveing data, you can just use T-SQL query to get the data. Power BI will generate Power Query which you can edit it in Query Editor (Advance Editor). For Power Query (M language), please see: Power Query (informally known as "M") Formula reference.

For retrieved dataset, you can use DAX to add measure and calculated column for your calculation. For DAX tutorials, please see: DAX basics in Power BI Desktop

QuickStart: Learn DAX Basics in 30 Minutes

SQL Server DAX Tutorial Overview

Regards,