WINDOWs Relation parameter only contains columns added by DAX table functions. This is not supported

[kroman]

Hi All

I have a 100 rows table and trying to get a bunch of rows with WINDOW command but getting following error

on following query

EVALUATE  
     VAR Window1 =  WINDOW(1, ABS, 5 , ABS ,Data100Rows, MATCHBY([ID])) 
RETURN Window1

Any idea what I am doing wrong?

Thanks

[Anonymous]

Hi @kroman,

According to the documents, the relation parameter of the WINDOW function is optional and it specifies a table expression from which the output row is returned. If you specified, all columns in partitionBy need to from this or a related table.

WINDOW function (DAX) - DAX | Microsoft Learn

In addition, you can also take a look at the following blog about window function usage if it helps:

Introducing window functions in DAX - SQLBI

Regards,

Xiaoxin Sheng