Lists as function arguments

Excel has recently made it easier to work with formulas that use arrays and constants – you no longer have to save them by pressing CTRL+SHIFT+ENTER! We can now use lists of values, given in curly brackets, as function arguments. This is great news, and the possibilities are manifold. In the following post, you will be able to see the real application of this feature…

Decomposition Tree

Decomposition Tree is a Power BI visual that allows data analysis according to multiple reporting dimensions. You can view it as a sophisticated drill down tool. It performs data aggregation and gives the possibility of drilldown according to the given dimensions, and it also contains elements of artificial intelligence that help in the analysis and indicate the solution.