![Power BI Unpivot Columns](https://www.gcomsolutions.com/wp-content/uploads/2017/12/00100-Power-Query-Unpivot-Preview2.gif)
Similar Posts
![Power BI Formal and Informal Hierarchies](https://www.gcomsolutions.com/wp-content/uploads/2020/05/Formal-Date-Hierarchy.png)
Power BI Formal and Informal Hierarchies
In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to…
![The CALCULATE Function is a DAX TARDIS](https://www.gcomsolutions.com/wp-content/uploads/2020/07/tardis-and-report-768x369.png)
The CALCULATE Function is a DAX TARDIS
In spite of its bland name, the CALCULATE function is the most important function in the DAX language and by far the most widely used in advanced DAX calculations. The power of the CALCULATE function stems from the fact that it allows you to change the context in which a DAX calculation takes place. One…
![Parameterizing SQL Server Connections](https://www.gcomsolutions.com/wp-content/uploads/2020/05/image200-768x432.png)
Parameterizing SQL Server Connections
Query Parameters allow you to make the content of a report dependent on one or more parameter values. If we parameterize a data source, then we can update all our queries using that data source simply by specifying a different parameter value. In this demonstration, we will parameterize the name of the SQL Server instance…
![Easily Change All Data Sources from Excel to SQL Server](https://www.gcomsolutions.com/wp-content/uploads/2021/04/Easily-Change-All-Data-Sources-from-Excel-to-SQL-Server-768x403.png)
Easily Change All Data Sources from Excel to SQL Server
This blog post will show you how to Easily Change All Data Sources from Excel to SQL Server in a given solution. The idea of using power query parameters to rapidly change which data sources your tables are coming from, has been around for a long time. What we are going to do in this…
![Power BI MCSA Certification Tips – Part 5: Fill Down](https://www.gcomsolutions.com/wp-content/uploads/2019/10/image002-768x283.jpg)
Power BI MCSA Certification Tips – Part 5: Fill Down
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…
![New Power BI Currency Conversion Solution](https://www.gcomsolutions.com/wp-content/uploads/2021/09/Currency-Conversion-768x408.png)
New Power BI Currency Conversion Solution
A new Power BI solution has been added to our library. In this solution, we use parameter tables to allow the user to control key aspects of a currency conversion dashboard. The dashboard allows the user to track the conversion rate from any one currency to another in a basket of 15 currencies, and to…