Inside the Knowledge Evaluation Expressions (DAX) language, new information fields may be derived from current information inside a desk, and even from information residing in a related desk. This enables for the creation of personalized metrics, flags, or categorized values with out altering the supply information. As an example, a “Whole Gross sales” column could possibly be added to a “Merchandise” desk by summing associated values from an “Orders” desk. This dynamically updates each time the underlying information adjustments.
This capacity to create customized fields enriches information fashions and supplies deeper analytical insights. It permits for the event of complicated calculations and key efficiency indicators (KPIs) immediately inside the information 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 immediately inside the information mannequin promotes information integrity and simplifies information manipulation for end-users.
