Daily DAX : Day 20 INFO.EXPRESSION

 An information DAX function that uses the DMV (Data Model View) and returns a table that shows the model attributes for a given expresssion. 


The table has the following fields

Field Type
ID Integer
ModelID Integer
Name String
Description String
Kind Integer
Expression String
ModifiedTime DateTime
QueryGroupID Integer
ParameterValuesColumnID Integer
MAttributes String
LineageTag String
SourceLineageTag String
RemoteParameterName String
ExpressionSourceID Integer


https://dax.guide/info-expressions/

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 65 INFO.TABLEPERMISSIONS

 A metadata DAX function that returns a list of all table permissions in the current model with columns matching the schema rowset for table permissions objects Syntax INFO.TABLEPERMISSIONS(<RestrictionName>,<RestrictionValue>) Returns a table with the following fields Field Type ID Integer RoleID Integer TableID Integer FilterExpression String ModifiedTime DateTime State Integer ErrorMessage String MetadataPermission Integer https://dax.guide/info-tablepermissions/
Read more

Daily DAX : Day 55 PV

A financial DAX function that calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal. Syntax PV(<Rate>, <Nr_of_Periods>,<Payments_per_period>,<Future_Value>,<Type>) https://dax.guide/pv/
Read more