Category Archives: Uncategorized

PowerBI DAX – SAMEPERIODLASTYEAR

By | June 16, 2020

In the previous post we saw the shortcomings of using ParallelPeriod DAX function when it comes to summarizing data against a different dimension attribute. This problem can be overcome by using the DAX Formula SAMEPERIODLASTYEAR. Notice how this function can retrieve results for the same period of the previous year but won’t be able to… Read More »

PowerBI DAX – ROUND

By | June 16, 2020

Often the result of a calculation will have decimal places. However it is may not be required to show the decimal places at the time of visualization. In such cases you can use ROUND to truncate the output to the required number of decimal places. This can also be achieved in a number of other… Read More »

PowerBI DAX – RANKX

By | June 16, 2020

In our previous post we saw how to identify the top N Sales Persons a common follow up to this task it to rank the Sales Persons as well. In this post we explore how to RANK the Sales person based on the total Sales Amount. Ranks = RANKX(ALL(‘Dimension Employee'[Employee]),SUMX(RELATEDTABLE(‘Fact Order’),’Fact Order'[Total Including Tax])) The… Read More »

PowerBI DAX – Percentile.Ex

By | June 16, 2020

Percentile is a great way to find distribution of data across your range of values. It give a great feel for how the data is distributed and is especially useful for analysis over demographics etc. Percentile is an indication of how what is the upper bound for the value at a particular percentile value. Consider… Read More »

PowerBI DAX – PARALLELPERIOD

By | June 16, 2020

Often in Business Intelligence developers are required to create Measures based on time series analytics like compare this year sales with last years. In such cases you can use the Parallel Period Measure to aggregate the data based on dates in the calendar. This is especially useful when trying to identify trends such as increase… Read More »

PowerBI DAX – ISBLANK

By | June 16, 2020

A common issue with database sources is the presence of NULL values in column. When this data is imported into PowerBI it can often skew the report and graphs. It becomes important to identify such null values and handle them when reporting. Keep in mind Blank mean Null and not ” or #N/A or some… Read More »

PowerBI DAX – IF

By | June 16, 2020

Conditional logic is a core aspect of any report, most often we see something similar to formatting the output based on some condition or value. However we can use IF function in DAX for more than just changing the color of a value. In our previous post we explored how to use FIND. In this… Read More »

PowerBI DAX – FORMAT

By | June 16, 2020

As its name suggests it is used to change the format of a particular value. Often used with dates it’s a great way to change the look of a date of number to reflect regional settings. In this example we use format to represent the total tax amount from the Orders table in a currency… Read More »

How to Increase transfer rate when copying to External HDD

By | May 23, 2020

Recently I had to purchase an additional external hard disk to back up my data. While creating a system image of the laptop I noticed that it was taking far too long. On further inspect I found out the transfer rate was far lower than promised. This post will explain how to identify and fix… Read More »

Database Options: – Filestream

By | May 3, 2020

Filestream is a great feature for databases that have to handle a large volume of BLOB data. It allows the DBA to store data in Filesystem folders rather than data pages within SQL Server. Since the filesystem is meant to store and work with such data it makes it a perfect candidate for this feature.… Read More »