I have a table named "TicketData" and it has many columns. What I want to do is show a filtered view of this table in another table. I opened query editor and filtered everything down, except I have one additional filter needed and that is a date reference in a cell on another tab. The other tab is named "ABN Chart". I want that cell to filter the column named "Created Date".
我有一个名为“TicketData”的表，它有很多列。我想要做的是在另一个表中显示该表的过滤视图。我打开了查询编辑器并将所有内容过滤掉，除了我需要一个额外的过滤器，这是另一个选项卡上单元格中的日期引用。另一个选项卡名为“ABN Chart”。我希望该单元格过滤名为“创建日期”的列。
Example G5 in "ABN Chart" sets the filter of column 'TicketData'[Created Date] of the power query. I believe this can be done in the advanced query editor, but I don't know how. *I can change G5 to named reference if needed.
“ABN图表”中的示例G5设置电源查询的列'TicketData'[创建日期]的过滤器。我相信这可以在高级查询编辑器中完成，但我不知道如何。 *如果需要，我可以将G5更改为命名参考。
1 个解决方案
#1
0
I created another column in the original table called "InRange" and just pointed it to match the cell. This is the desired behavior.
我在原始表中创建了另一个名为“InRange”的列，并指出它与单元格匹配。这是理想的行为。
#1
0
I created another column in the original table called "InRange" and just pointed it to match the cell. This is the desired behavior.
我在原始表中创建了另一个名为“InRange”的列，并指出它与单元格匹配。这是理想的行为。