Forum Discussion
kroman
Helper II
Helper IIWINDOWs Relation parameter only contains columns added by DAX table functions. This is not supported
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 Window1Any idea what I am doing wrong?
Thanks
1 Reply
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
