DAX - 多个表和多个表Power BI 导入中包含度量的列

发布于 2025-01-19 00:17:20 字数 884 浏览 4 评论 0原文

我正在编写执行Power BI SQL Server分析服务数据库导入的DAX查询。我想限制要使用的字段和记录。我不知道如何在查询中包括措施。任何帮助将不胜感激！

这起作用：

EVALUATE (
SUMMARIZECOLUMNS (
'Date PT'[Calendar Date PT],
'Date PT'[Fiscal Month PT],
'Date PT'[Fiscal Year PT],
'Issue Code'[Code 2],
'Planning Cat'[Planning Area],
FILTER('Date PT', 'Date PT'[Fiscal Year PT]= "FY22"),
FILTER('Planning Cat', [Planning Area]= "NOA")
)
)

我需要按预订日期添加销售（一种措施），我会发现一个错误，说“在此表达式中找不到或找不使用”

这不是工作

EVALUATE ( 
SUMMARIZECOLUMNS (
'Date PT'[Calendar Date PT],
'Date PT'[Fiscal Month PT],
'Date PT'[Fiscal Year PT],
'Issue Code'[Code 2], 
'Planning Cat'[Planning Area],
'Sales'[Sales by Booked Date],
FILTER('Date PT', 'Date PT'[Fiscal Year PT]= "FY22"), 
FILTER('Planning Cat', [Planning Area]= "NOA") 
) 
)

我已经尝试了所有我能找到的一切，但似乎没有任何作用。如果我省略了措施，则可以按预期工作。

原文

I am writing a DAX query to be used while performing a Power BI SQL Server Analysis Services database Import. I want to limit the fields and records to be used. I cannot figure out how to include measures in my query. Any help would be appreciated!

This works:

EVALUATE (
SUMMARIZECOLUMNS (
'Date PT'[Calendar Date PT],
'Date PT'[Fiscal Month PT],
'Date PT'[Fiscal Year PT],
'Issue Code'[Code 2],
'Planning Cat'[Planning Area],
FILTER('Date PT', 'Date PT'[Fiscal Year PT]= "FY22"),
FILTER('Planning Cat', [Planning Area]= "NOA")
)
)

I need to add in Sales by Booked Date (a measure) and I get an error stating that this field "cannot be found or cannot be used in this expression"

THIS DOES NOT WORK

EVALUATE ( 
SUMMARIZECOLUMNS (
'Date PT'[Calendar Date PT],
'Date PT'[Fiscal Month PT],
'Date PT'[Fiscal Year PT],
'Issue Code'[Code 2], 
'Planning Cat'[Planning Area],
'Sales'[Sales by Booked Date],
FILTER('Date PT', 'Date PT'[Fiscal Year PT]= "FY22"), 
FILTER('Planning Cat', [Planning Area]= "NOA") 
) 
)

I have tried everything I can find but nothing seems to work. If I leave a measure out, it works as expected.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

腹黑女流氓 2025-01-26 00:17:20

试试这个方法：

EVALUATE  
ADDCOLUMNS(
   SUMMARIZECOLUMNS (
      'Date PT'[Calendar Date PT], 
      'Date PT'[Fiscal Month PT], 
      'Date PT'[Fiscal Year PT], 
      'Issue Code'[Code 2], 
      'Planning Cat'[Planning Area], 
      FILTER(
         'Date PT', 
         'Date PT'[Fiscal Year PT]= "FY22"
      ), 
      FILTER(
         'Planning Cat', 
         [Planning Area]= "NOA"
      ) 
   ),
   "@SalesByBookedDate", CALCULATE ( 'Sales'[Sales by Booked Date] )
)

Try this way:

EVALUATE  
ADDCOLUMNS(
   SUMMARIZECOLUMNS (
      'Date PT'[Calendar Date PT], 
      'Date PT'[Fiscal Month PT], 
      'Date PT'[Fiscal Year PT], 
      'Issue Code'[Code 2], 
      'Planning Cat'[Planning Area], 
      FILTER(
         'Date PT', 
         'Date PT'[Fiscal Year PT]= "FY22"
      ), 
      FILTER(
         'Planning Cat', 
         [Planning Area]= "NOA"
      ) 
   ),
   "@SalesByBookedDate", CALCULATE ( 'Sales'[Sales by Booked Date] )
)

回复收藏 0 原文

~没有更多了~