Power bi sync filters across pages are used to filter different pages in a Power BI dashboard. In Power BI, we call them sync slicers. With the help of power bi sync filters or slicers, you don’t need to put slicers on every tab or page in the dashboard because all pages will get synchronized…
The idea of this tutorial is to help anyone looking to learn DAX. DAX, as a subject, is a vast topic, and hence it will only be better to get started with some introduction and then learn DAX in parts. In today’s post, we will learn some key concepts in DAX and slowly progress to…
To state the obvious, both DAX vs MDX have their own purposes to be able to co-exist. MDX can be used to query data from a cube and do a pivot of that data while DAX, being more of an expressions language than a query language, cannot be used similarly. Hence before we look at…
It is very critical for organizations of all sizes to be able to use data and derive meaningful insights from it. The results are always presented as reports or dashboard visualizations. Microsoft offers Power BI vs SSRS as two report development tools – each with their own strengths and use cases to be chosen for….
Power BI measure is the core of dax. Whenever you start working on your power bi projects, you don’t need to create power bi measure right away. Measures execute on report level or an aggregate level to compute the provided data. We need to import the sample Adventureworks excel dataset. It has different sheets in…
Many seasoned BI Reporting professionals would have used T-SQL extensively, either in the initial stages of their career as a database developer writing numerous lines of a stored procedure or as part of the BI report authoring role to generate historical reports using SSRS or Crystal reports. When they gradually move to use Power BI…
Power BI sample data is the starting point to jump into the world of Power BI. Sometimes it is very time-consuming to find Power BI Sample data to download. There are different versions of AdventureWorks data files available, but it is hard to find the correct one, especially for the beginners. Below you can find…