Azure data sync is a great tool for those people looking for a quick and easy way to move data from on premise systems to the cloud. It […]
When does SQL Server Cache an execution plan?
Ever wondered under what circumstances SQL Server cache an execution plan. What is the difference between simple and forced parametrization. What are the disadvantages of plans being cached? […]
Visual Studio – The process cannot access the file because it is being used by another process
Cannot delete the file “C:\……t\LoadExcelFiles.ispac”: The process cannot access the file ‘C:\…..LoadExcelFiles.ispac’ because it is being used by another process The above error common message that we encounter […]
PowerBI DAX – USERELATIONSHIP
A common issue faced when working with PowerBI is the limitation of having only one Active relationship between two tables. While this is a not an issues when […]
PowerBI DAX- TREATAS
Once we are able to create virtual tables within PowerBI using Functions such as EVALUATE , CALCULATE TABLE etc it might be required to filter the contents of […]
PowerBI DAX- TOTALYTD
A very useful kind of report is called a cumulative report. Which is based on summarizing data cumulatively. This means we can see the area chart as progressively […]
PowerBI DAX – TOPN
Another commonly used function is the TOPN function. It is used for both TOP and BOTTOM use cases. In this example to demonstrate the basics we are first […]
PowerBI DAX – SWITCH
Switch is a DAX function that is used frequently to create custom groups and classifications. In this example we use Switch to create a column called approval where […]
PowerBI DAX – SUMMARIZE
A useful function when measures need to be created on top of summarized data the SUMAMRIZE Function as its name suggests returns a table containing aggregates based on […]
PowerBI DAX – SUM and SUMX
In this post we cover the difference between the DAX Formula SUM and SUMX. If you are even somewhat familiar with EXCEL you already know what SUM does. […]