Daily DAX : Day 68 INFO.ATTRIBUTEHIERARCHIES

 This is a meta data DAX function that returns a table with attribute information about Hierarchies in your dimension


    Syntax: INFO.ATTRIBUTEHIERARCHIES(<Dimension>)

        <Dimension> is a reference to a dimension table in your data model.

    Return Value: This function returns a table with columns for each attribute hierarchy in the specified dimension. The table includes:

        AttributeHierarchyID: A unique identifier for the attribute hierarchy.

        AttributeHierarchyName: The name of the attribute hierarchy.

        AttributeHierarchyDefaultMember: The default member for the attribute hierarchy, if defined.

        AttributeHierarchyOrdered: A boolean indicating whether the hierarchy is ordered.

        AttributeHierarchyIsVisible: A boolean indicating if the hierarchy is visible in the user interface.


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

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