VIEW Data Analysis Expressions

A structured compilation of information covering various UK sectors, including economy, demographics, and public services.
Post Reply
[email protected]
Posts: 12
Joined: Tue Jan 07, 2025 4:29 am

VIEW Data Analysis Expressions

Post by [email protected] »

Modeling
Dynamic format strings for measures (generally available)
Dynamic format strings for measures are now generally available, allowing for complete flexibility in displaying measures in graphical elements. These format strings can be conditionally applied using Data Analysis Expressions (DAX), based on the value of the measures, applied filters, or to add additional information such as units.



Introducing INFO. (DAX) Functions
The DAX query view has added new DAX functions qatar whatsapp resource to retrieve metadata about your semantic model using the DAX INFO functions. Four of these functions are now also available as DAX INFO.VIEW functions, which transform IDs into descriptive names and can be used in calculated tables in the semantic model, as well as executed in the DAX query view.





Including these functions as calculated tables ensures that your model is automatically documented and kept up to date with the latest changes. Not only can these functions be used in calculated tables, but they also allow you to display the name or value of a column that previously only displayed an ID.


INFO.VIEW.TABLES(): Provides information about the tables in your model, including each table's storage mode. It also allows you to quickly identify tables marked as date tables by the Time data category.
Post Reply