In the first two parts (part 1 and part 2) of the blog we explored the Show details functionality of a Pivot table in Excel. Now we look at another hidden feature that will help you limit distractions. Whenever you connect to...
Tag - Dataset
Data Types has been part of Excel for some time now, but a lot of people is not familiar with it. You can find them under the Data tab. You might have wondered what they are for? They are built-in datasets about common...
Turn Best Practice Analyzer recommendations into Custom Actions in Tabular Editor. Improve your data models with a few clicks.
I wanted to find an easy-to-use documentation script for my data models. In Tabular Editor`s documentation there is a useful script for generating documentation. I thought I will use what Daniel Otykier created as a starting...
When I began working with Power BI, all the datasets I created were intended to support the reports I was building. However, as more of my colleagues started embracing Power BI, they also wanted to create their own reports...