Data Bear – Power BI Training and Consulting

Call us Today! (020) 8720 6880 | info@databear.com

Uncategorized

Data Preparation Part 6 – Star Schema Power BI

Power BI Relationship Modelling – Star Schema In our blog post called: Relationship Modelling – Part 1 we spoke about relationships in Power BI and what it entails. We also spoke about the importance thereof to really understand how to create relationships. This blog post will look at relationship modelling, the means of building your […]

Data Preparation Part 6 – Star Schema Power BI Read More »

Data Preparation Part 3 – Merging and Appending Queries

Power BI Merging and Appending Queries Let’s start off by explaining what merging and appending queries in Power BI entails and the difference between the two. In short, when you have one or more columns that you’d like to add to another query, you merge the queries. When you have additional rows of data that you’d like

Data Preparation Part 3 – Merging and Appending Queries Read More »

Power BI DAX TOPN function

DAX TOPN This blog post will outline the Power BI DAX TOPN function. The DAX TOPN function is a very practical useful function as we often want to see the top performing products by sales, region or shop. TOPN syntax TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…]) Parameters n_value The first parameter will determine the number

Power BI DAX TOPN function Read More »

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD

DAX Time Intelligence Functions In this blog post, we are going to look at three DAX time intelligent functions. These DAX time intelligent functions are PARALLELPERIOD, DATEADD and SAMEPERIODLASTYEAR. I know many of you will say the functions sound very similar and that they have more or less the same functionality. This is not the

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD Read More »

Power BI: Displaying Totals in a Stacked Column Chart

Total Value in a Stacked Column Chart I have recently run into the frustration that I cannot display a data label for the Total Value for a stacked column chart in Power BI. Data labels are only displayed for each category of my stacked chart, however, no data label is displayed for the Total Value

Power BI: Displaying Totals in a Stacked Column Chart Read More »

Power BI: Pivot and Unpivot Columns

Power BI: Pivot and Unpivot Columns

Pivot and Unpivot walkthrough in Power BI Power Query in Power BI provides very effective functionality to pivot and unpivot columns. For the pivot functionality you turn rows to columns and for the unpivot functionality the inverse is true where columns are transformed into rows. Power BI Pivot We will be working with the following

Power BI: Pivot and Unpivot Columns Read More »

Power BI Desktop Summary Update – March 2019

March Update of Power BI Desktop March sees another exciting release for Power BI Desktop update. There are great additions to reporting in Power BI, especially with the addition of the Report page tooltips (preview). Analytics sees some improvements to Q&A with the ‘did you mean’ functionality as well as some formatting updates for maps.

Power BI Desktop Summary Update – March 2019 Read More »