What is the DAX syntax to return a single field from an INFO table/view?

DAX
2

@Greg,

To retrieve a single [Value] from your filtered table you can use SELECTCOLUMNS to create a single-column table containing just the [Value] column:

EVALUATE
VAR _BaseTable =
    ADDCOLUMNS(
        SELECTCOLUMNS(
            INFO.ANNOTATIONS(),
            "ID", [ID],
            "Name", [Name],
            "Value", [Value]
        ),
        "Junk", 999
    )
VAR _FilteredTable = 
    FILTER(
        _BaseTable, 
        [Name] = "__PBI_TimeIntelligenceEnabled"
    )
RETURN
SELECTCOLUMNS(
    _FilteredTable,
    "Value", [Value]
)
1 Like