功率bi和qliksense中的表达 [英] Expression in power bi and qliksense

问题描述

我有2个文件，一个在qliksense中，另一个在power bi中。..两个文件都具有相同的表和关系。

qliksense表达式是

  if（[帐单凭证currency_WAERK] ='USD'，
总和（{< [Billing Type_FKART]-= {'ZG2 '，'ZL2'}>} [Billing Sales Amount_NETWR]）* 139.2，
 sum（{< [Billing Type_FKART]-= {'ZG2'，'ZL2'}>} [Billing Sales Amount_NETWR] ））
  

和

power bi表达式是

已更新

 总销售额变量= 
 CALCULATE（
 SUMX（
 VALUES（test_billing_doc_header [Billing doc.currency_WAERK]）），
 IF（
 test_billing_doc_header [Billing doc.currency_WAERK] = USD ，
 139.2，
 1 
）* SUM（test_biilingg_doc_item [Billing Sales Amount_NETWR]）
），
 test_billing_doc_header [Billing Type_FKART]<> ZG2& ;& test_ billing_doc_header [Billing Type_FKART]<>  ZL2 
）
  

现在的问题是qliksense表达式显示值 26,599,175,877.32
和power bi显示 6,800,260,015,222,45

我希望qliksense值在power bi中。

这是power bi文件的链接。。

  if（[Billing doc.currency_WAERK] ='USD'，
 sum（{< Fiscal_Year = {'2016'，'2017'}，[Billing Type_FKART ]-= {'ZG2'，'ZL2'}>} [Billing Sales Amount_NETWR]）* 139.2，
 sum（{< Fiscal_Year = {'2016'，'2017'}，[Billing Type_FKART]- = {'ZG2'，'ZL2'}>} [Billing Sales Amount_NETWR]））
  

2. 我还看到数据存在差异，因为PowerBi中的货币已经转换，而QlikSense中的货币没有转换。请使用直线表和数据透视表来分析数据，以便您更轻松地进行分析：

Power BI表（不进行任何转换-只需简单的总和并过滤以选择Years和FKART）：

QlikSense表（具有集合分析，并且结果与不带货币换算的Power Bi中的结果相同）：

I have 2 files one is in qliksense and other is in power bi .. both have same tables and relationships..

qliksense expression is

if([Billing Doc. currency_WAERK] = 'USD',
sum({<[Billing Type_FKART] -={'ZG2','ZL2'}>}[Billing Sales Amount_NETWR])*139.2,
sum({<[Billing Type_FKART] -={'ZG2','ZL2'}>}[Billing Sales Amount_NETWR]))

and

power bi expression is

UPDATED

Total Sales Variable = 
CALCULATE ( 
    SUMX ( 
        VALUES ( test_billing_doc_header[Billing Doc. currency_WAERK] ),
        IF ( 
            test_billing_doc_header[Billing Doc. currency_WAERK] = "USD",
            139.2,
            1
        ) * SUM ( test_biilingg_doc_item[Billing Sales Amount_NETWR] )
    ),
    test_billing_doc_header[Billing Type_FKART] <> "ZG2" && test_billing_doc_header[Billing Type_FKART] <> "ZL2"
)

now the problem is qliksense expression show value 26,599,175,877.32 and power bi shows 6,800,260,015,222,45

and i want qliksense value in power bi ..

this is the link for power bi file .. https://www.dropbox.com/s/i8aazcb19zt50l5/test4.pbix?dl=0

and this is for qliksense https://www.dropbox.com/s/jltgdls5rbintn4/test.qvf?dl=0

any help ?

解决方案

1. Qliksense expression is correct but in table with [Fiscal_Year] field there is no data (calendar is not calculated in loading script). I've changed it to Invoice_year which is not missing and result is:

if([Billing Doc. currency_WAERK] = 'USD',
sum({< Fiscal_Year = {'2016','2017'},[Billing Type_FKART] -={'ZG2','ZL2'}>}[Billing Sales Amount_NETWR])*139.2,
sum({< Fiscal_Year = {'2016','2017'},[Billing Type_FKART] -={'ZG2','ZL2'}>}[Billing Sales Amount_NETWR]))

2. I see also that there are difference in data as currency in PowerBi is already converted and in QlikSense not. Please use straight tables and pivot tables to analyze your data so it will be easier for you:

Power BI table (without any conversions - just simple sum and filter to select Years and FKART):

QlikSense table (with set analysis and if result is the same as in Power Bi without currency conversion):

这篇关于功率bi和qliksense中的表达的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！