Throughout the Information Evaluation Expressions (DAX) language, new knowledge fields will be derived from present knowledge inside a desk, and even from knowledge residing in a linked desk. This permits for the creation of personalized metrics, flags, or categorized values with out altering the supply knowledge. For example, a “Complete Gross sales” column could possibly be added to a “Merchandise” desk by summing associated values from an “Orders” desk. This dynamically updates at any time when the underlying knowledge modifications.
This potential to create customized fields enriches knowledge fashions and gives deeper analytical insights. It permits for the event of complicated calculations and key efficiency indicators (KPIs) instantly inside the knowledge mannequin, enhancing report improvement velocity and effectivity. Previous to this performance, such computations usually required preprocessing or complicated queries, leading to much less versatile reporting. Integrating derived fields instantly inside the knowledge mannequin promotes knowledge integrity and simplifies knowledge manipulation for end-users.