POWER BI TUTORIAL : Using Variables in DAX

Earlier this year, new version of DAX was released. One of the key features with this release is the support for variables. Variables makes writing DAX code easier. Variables also make code easier to read and understand. Download sample data here. Data represents sales for a particular store. Products are categorized by seasonality and color. We want to calculate the

Read more

More Robust Tile Pinning to Dashboards Introduced in Last Power BI Service Update


Microsoft is making pinning a tile to a dashboard more user friendly with its last weekly Power BI service update. It was not always apparent what dashboard the tile would be pinned to; therefore, the dialog box above will make it much clearer to a user. More details for the weekly update are available here. There are couple of interesting

Read more

Power BI Desktop : Merge Query Options

In Power BI Desktop, there are multiple options available when using Merge Query feature. This tutorial reviews each of the options. Data for the tutorial can be obtained by downloading Excel file from here . The file has Product sheet which has details of all the products my company sells The file also has a Manufacturer sheet. This lists the

Read more
« Older Entries