By Michele Washington on 9/1/2019 6:50 PM
Sometimes you may want to sort your data in an order other than alphabetically or numerically.  One way to achieve this option is by creating a custom sort column.

TOOLS:  Microsoft Power Bi Desktop version 2.71.5523.821 64-bit (July 2019)

TASK:  Add custom sort column to data sheet

SOLUTION:

Using Microsoft Power Bi Desktop from the selection bar on the left select the ‘Data’ icon.  Under the ‘Home’ tab on the menu ribbon select ‘Enter Data’. 

PBI_NewTable1

 

A window titled ‘Create Table’ will pop-up. 

PBI_NewTable 2

...
By Michele Washington on 9/1/2019 1:58 PM
Data results that represent money or currency display as unformatted.  In this post I will show how to format the results as currency.

TOOLS:  Microsoft SQL Server Management Studio v17.3; AdventureWorks2008

TASK:  Display unformatted SQL results as currency

SOLUTION:

The image below shows the unformatted SQL results.

image

To display the ‘Sales Last Year’ and ‘Sales YTD’ results as currency add the highlighted function to your query.

FORMAT(SalesLastYear, 'C')

FORMAT(SalesYTD , 'C')

 

image

...
By Michele Washington on 8/26/2019 8:31 PM

TOOLS:  Microsoft Power BI Desktop v2.72.5556.801 64-bit (August 2019)

TASK:  Data imported from excel does not display the first line of data as the column headings.  Use first row of data as column names.

SOLUTION:


 

By Michele Washington on 11/12/2017 10:19 PM

Whether you are a beginner or experienced writing queries you may receive an error message when you execute a query. 

SQL identifies errors within a query by line number.  Instead of counting through each line it is much more efficient to use the Line numbers option.

TOOLS:  Microsoft SQL Server Management Studio v17.2

TASK:  Select Line numbers option.

SOLUTION:

Using SQL Server Management Studio from the menu bar select Tools then Options from the dropdown menu.

image

By Michele Washington on 11/11/2017 12:36 PM

Hello my name is Michele and I plan to post on my adventures as I learn new technologies.


 

image

Most of my posts will use AdventureWorks2016 database that you can get here:

AdventureWorks2016.bak

Writing SQL Queries: Formatting Numbers as Currency
Writing SQL Queries: Display Line Numbers
Welcome To My Blog