PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth.

The series of blog posts I wrote last year on semantic model memory usage, in particular this post on the query memory limit and the “This query uses more memory ...

For fixing Windows errors, we recommend Fortect: Fortect will identify and deploy the correct fix for your Windows errors. Follow the 3 easy steps to get rid of Windows errors: The INDEX function in ...

To count distinct values in Excel, you need to add the unique values with the first of the duplicate value. Although it sounds complicated, you will see that there are a few simple formulas to apply ...

Some good news for those of you using DirectQuery mode in Power BI: the ApproximateDistinctCount DAX function, which returns an estimate of the number of the distinct values in a column and which can ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function. Microsoft Excel’s Data Validation feature provides an easy way to create a dropdown at ...

Duplicates aren’t bad, but you may need to know how many times a value is repeated or how many unique values are in a data range. Here’s how to tackle these tasks in Excel. Counting duplicate values ...