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 &ls...

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. To display the ‘Sales Last Year’ and ‘Sales YTD’ results as currency add the highlighted function to your query....

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: Select 'Get Data' from the top navigation bar, then select 'Excel'. You will notice the column headings in the example below are 'Column1', 'Column2', etc. The column headings should be the data in the first row. Select 'Lo...

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...

Hello my name is Michele and I plan to post on my adventures as I learn new technologies. Most of my posts will use AdventureWorks2016 database that you can get here: AdventureWorks2016.bak...