We have always had to measure the worth of things. Everybody has things they want and in order to get them they need to trade. With trade came […]
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 […]
29 DAX Functions you must know
PowerBI has been the preferred BI tool for a large number of companies in recent times. As the tools get adopted we have seen a number of reporting […]
PowerBI DAX – VAR
A very useful way to work with DAX functions is to use VAR. VAR is a form of variable in which results can be stored temporarily without having […]
PowerBI DAX- USERNAME
This is a function that may not be used as frequently as it used to be but it is likely you will encounter it in older PowerBI Reports […]
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 […]