Wk6 Dq2

SYM-409 WK6 DQ2. 150 WORDS OR MORE

Suppose you have a table that contains total sales for several years. Explain how you could explore the calculated data for specific year.

REPLIES 80 WORDS OR MORE

A Trevor Stoutt

In order to explore the calculated data for a specific year in Power BI, the following steps need to be followed.

Open the program and select the table that contains fields pane.

Grab the year section of the column and drag it to the filter section.

Use drop down arrow to navigate to the year that you want to explore.

Explore the different visual tools such as charts and graphs.

You could explore a specific year in various ways, you could drag different months or quarters. This would allow you to make predictions, look at trends or look at revenue.

B Joshua Victor

To explore calculated data for a specific year in SQL Server Management Studio (SSMS), Open a new query window and write a query that selects the total sales or calculation for the specific year you want to explore. It will look something like this:

SELECT TotalSales

FROM SalesTable

WHERE Year = ‘2021’

 

Make sure you are using the names of the tables and columns specific to the database you are accessing.

When you execute the query, this should provide the desired results.

C ONE MORE TO COME