This PR improves the ParserReference of structured (table) references. Consider the following formula:
=SUM(Sales_2[Jan]:Sales_2[Feb])
Currently two parser references are generated. In fact, it can be seen as one table reference with two columns. Similar to cell ranges (e.g. A1:B10), would like to merge these two parser references into one parser reference. This PR provides the implementation and unit tests.
Some remarks:
Table references are only merged if they are combined with the intersect operator :
Table references are only merged if they refer to the same table
Table references are only merged if they each refer to one column
The table specifier is only taken over if it the same in both references. Otherwise, no specifier is applied.
This PR improves the
ParserReference
of structured (table) references. Consider the following formula:=SUM(Sales_2[Jan]:Sales_2[Feb])
Currently two parser references are generated. In fact, it can be seen as one table reference with two columns. Similar to cell ranges (e.g. A1:B10), would like to merge these two parser references into one parser reference. This PR provides the implementation and unit tests.
Some remarks:
: