dax function power query code example

Example 1: sql query in dax power bi

SELECT * 
FROM DimProduct
WHERE Color = 'Red'

Example 2: sql query in dax power bi

EVALUATE
FILTER ( Product, Product[Color] = "Red" )