Articles

Imagine you have a portfolio of seven products and you want to measure sales for each, the sum of each…

In this post, we are going to take a look at the data table option under What if analysis…

What is Scenario Manager in Excel? Scenario Manager in Excel is used to compare data side by side and…

Intro to What-If Analysis From individuals to big conglomerates everyone wonders on a question with What if? Big giants…

People often ask questions on “What-if ?” Say for example What if I had a few more votes would…

DAX GROUPBY Function is categorized under Filter functions. Purpose of DAX GROUPBY Function This function is to get a…

DAX SUMMARIZECOLUMNS function is categorized under Filter functions. SUMMARIZECOLUMNS, is a replacement of SUMMARIZE and does not require the…

DAX SUMMARIZE Function is categorized under Filter functions. This function can be done with ROLLUP function also. Purpose of…

DAX PATHITEMREVERSE function is categorized under the Parent/Child function. This function used to find the specified position of the…

Power Query M Table.ViewFunction is categorized under Table Functions. This function is used to create a view function based on…

Power Query M ItemExpression.Item Function is categorized under Table Functions. This function is used to represent the AST node for…

Power Query M ItemExpression.From Function is categorized under Table Functions. This function is used to returns the AST(Abstract Syntax Trees)…

Power Query M RowExpression.Column Function is categorized under Table Functions. This function is used to return an AST that represents…

Quick Analysis The Ctrl key + Q key is used to quickly analyze your data with the help of…

Flash Fill The Ctrl key + E key automatically fills values when a pattern is recognised in your data..

Display Emoji dialog box The Window logo key + . key helps to display the emoji dialog box, from…