Articles

Looking for specific information? Are large datasets making it difficult to find the information? Thankfully, Excel made it easy for…

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…

Homepage 5

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…

Homepage 5

Power Query M Embedded.Value Function is categorized under Value Functions. This function is used to access the value by name…

Power Query M Value.NativeQuery Function is categorized under Value Functions. This function is used to evaluate the provided query(s) against…

Power Query M Value.Divide Function is categorized under Value Functions. This function is used to divide value1(s)&value2(s). Purpose of Power…

Power Query M Value.Multiply Function is categorized under Value Functions. This function is used to Multiply value1(s)&value2(s). Purpose of Power…

Homepage 5