Category Archives: PowerBI

Planning to switch to PowerBI ? It’s time your reports looked great. PowerBI will help find meaningful information and insights with minimum effort. We know this because we help a number of companies from Startups to Fortune 500 companies migrate to PowerBI. Crisp clean reports on the go in seconds. Get in touch to find out more !!

FREE PowerBI session – Batch 2

By | August 27, 2020

It’s time for the next batch of PowerBI Sessions. This is a 3 hour free PowerBI Session for those whose careers have been affected by #Covid or those who feel their careers have slowed down in recent years and would like a relevant in demand skill. In this session we will be creating the below… Read More »

FREE PowerBI session – Batch 2

By | August 27, 2020

It’s time for the next batch of PowerBI Sessions. This is a 3 hour free PowerBI Session for those whose careers have been affected by #Covid or those who feel their careers have slowed down in recent years and would like a relevant in demand skill. In this session we will be creating the below… Read More »

Introduction to PowerBI

By | August 17, 2020

The Covid 19 situation has been tough for pretty much everyone and a lot of careers have come to an abrupt stop. If you feel your career opportunities are hampered by the lack of a particular skill I would like to help by providing a 3 hour introductory course to PowerBI. Why PowerBI? It’s almost… Read More »

29 DAX Functions you must know

By | June 16, 2020

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 scenarios from Basic excel porting to complex Machine Learning models. Regardless of how you plan to utilize PowerBI it is important to learn and understand the DAX… Read More »

PowerBI DAX – VAR

By | June 16, 2020

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 to create measures and then using them in others. For example you use Var to store the result of a particular group and then use the var… Read More »

PowerBI DAX- USERNAME

By | June 16, 2020

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 where RLS or row level security was implemented. The function returns the username of the user currently viewing the report. Using this information and mapping it against… Read More »

PowerBI DAX – USERELATIONSHIP

By | June 16, 2020

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 importing data it can make creating measures a hassle. An example of this scenario could be the use of calendar table for Order Date and Delivery Date.… Read More »

PowerBI DAX- TREATAS

By | June 16, 2020

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 the virtual table based on certain Input criteria. In such cases we can use the TREATAS function to apply filters to a Virtual or Actual Table as… Read More »

PowerBI DAX- TOTALYTD

By | June 16, 2020

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 growing as the year goes by. Charts such as these provide a clear indication of the long term trajectory of the sales and clearly indicates Sales for… Read More »