# Archive by Author

## DAX Context Quiz

Using context in your DAX calculations enables you to perform dynamic analysis, in which the results of a formula can change depending on the filter or slicer used. Understanding context and using it ...

## DAX Scenarios Quiz

Scenario analysis is an important aspect of business intelligence because it anticipates and provides valuable insights to a broad range of possible future outcomes. This type of analysis examines the...

## DAX Text Functions Quiz

Text functions manipulate strings and work with tables and columns in tabular models. Get to know more about DAX text functions when you take our online quiz.

## DAX Date Functions Quiz

Date is an important part of business analytics. When working with large data sets and multiple tables, it makes sense to create a Dates table and use time intelligence functions. These DAX date funct...

## Power BI Quiz

Power BI is a powerful analytics and reporting platform for businesses and organizations. Its ability to get rapid insights on the fly even with huge quantities of data sets has made it a favorite amo...

## DAX Function Quiz

DAX functions simplify the task of analyzing data and visualizing patterns.   Having the basic knowledge of the most frequently used DAX functions allow you to achieve great insights into your mo...

## Custom Visual Guide

0-9 100% Stacked Bar Chart100% Stacked Column Chart by Akvelon3AG Systems – Bar Chart With Relative Variance 3AG Systems – Column Chart With Relative Variance3AG Systems – Column Chart With Smal...

## DAX Quizzes

These DAX quizzes will test your knowledge of DAX functions and Power BI. Simply click on any of the six quizzes, read the questions carefully, and find the correct answer from the options provided. T...

## XNPV Function (DAX)

How does the XNPV function (DAX) work? The XNPV function (DAX) returns the present value for a schedule of cash flows that is not necessarily periodic. XNPV Formula Syntax XNPV(     &lt...

## XIRR Function (DAX)

How does the XIRR function (DAX) work? The XIRR function (DAX) returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. XIRR Formula Syntax XIRR(   ...