Query in DAX

[prasa]

How to write this simple query in DAX -

select columnA from table1 where ColumnBDate is Today(). 

[v-chuncz-msft · Accepted solution]

@prasa,

You may refer to the following DAX.

Table =
SELECTCOLUMNS (
    FILTER ( table1, table1[ColumnBDate] = TODAY () ),
    "columnA", table1[columnA]
)