Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Apply query changes error Power bi Too few arguments were passed for the sum function

Can't update my Power BI due to error: Too few arguments were passed for the sum function 

 

ErrorQueryUpdate.PNG

The query is simple and there are not syntax errors nor SUM function:

 

let Origen =

Csv.Document(File.Contents(\02.Dashboards\3. Dashboard Migration\Power BI\Tables\3010\SHIPMENTS_3010.csv"),[Delimiter=";", Encoding=1252]),

#"Encabezados promovidos" = Table.PromoteHeaders(Origen, [PromoteAllScalars=true]),

#"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promovidos",{{"CDTY_DESC", type text}, {"FLEX_QNTY1", Int64.Type}, {"FLEX_QNTY2", Int64.Type}, {"FLEX_QNTY3", Int64.Type}, {"FLEX_QNTY4", Int64.Type}, {"FLEX_QNTY5", Int64.Type}, {"FRM_HUBRGN_ZN_CD", type text}, {"FRM_PNT_TYP_ENU", Int64.Type}, {"FRM_SHPG_ADDR_ID", type text}, {"FRM_SHPG_LOC_NAME", type text}, {"AR_CSLD_RFRC_NUM", type text}, {"BS_WGT", type number}, {"CDTY_CD", type text}, {"CRTD_DTT", type date}, {"CUR_OPTLSTAT_ID", Int64.Type}, {"FRM_CTRY_CD", type text}, {"FRM_CTY_NAME", type text}, {"FRM_NAME", type text}, {"FRM_PKUP_DTT", type date}, {"FRM_PSTL_CD", type text}, {"FRM_SHPG_LOC_CD", type text}, {"LD_LEG_ID", Int64.Type}, {"RFRC_NUM_VBTY_ID", Int64.Type}, {"COMPANY_CODE", type text}, {"TRANSP_PLAN_POINT", type text}, {"CREATION_DATE", type datetime}, {"GOODS_ISSUE_DATE", type text}, {"REF_ID", type text}, {"CUSTOMER_SALES_ORDER", type text}, {"TEMP_CONDITION", type text}, {"EQUIPMENT_TYPE_SAP", type text}, {"TRUCK_SIZE_SAP", type text}, {"CUSTOMER_NAME", type text}, {"EXPORT_DOC_CREATED", type text}, {"BUSINESS_UNIT", type text}, {"SHIPMENT_TYPE", type text}, {"PLANING_CYCLE_TIME", type text}, {"CUSTOMER_PO_NUMBER", type text}, {"BUSINESS_UNIT_DESC", type text}, {"LOADNUM", type text}, {"SHIPPING_CONDITION", type text}, {"INCO", type text}, {"PURCHASE_ORDER_NUM", type text}, {"PURCHASE_ORDER_NUM_2", type text}, {"CONTAINER", type text}, {"SAP_PROFIT_CENTER", type text}, {"ARTICLE_NUMBER", type text}, {"SAP_SHIPMENT_STAGE", type text}, {"CUSTOMER_ID", type text}, {"TRANSP_PLANT", type text}, {"SYSTEM_ID", type text}, {"SAP_SHIPMENT_ID", type text}, {"SAP_SHIPMENT_TYPE", type text}, {"SHPM_NUM", type text}, {"TO_CTRY_CD", type text}, {"TO_CTY_NAME", type text}, {"TO_ENT_TYP_CD", type text}, {"TO_NAME", type text}, {"TO_PKUP_DTT", type date}, {"TO_PSTL_CD", type text}, {"TO_SHPG_LOC_CD", type text}, {"TOT_PCE", Int64.Type}, {"TOT_SKID", type number}, {"SHPM_PICK", Int64.Type}, {"PICK_CMPD_ARVL_DTT", type date}, {"PICK_CMPD_DPTR_DTT", type date}, {"PICK_CFMD_DTT", type date}, {"PICK_DPTR_RPTD_DTT", type date}, {"PICK_LAST_CMPD_ARVL_DTT", type date}, {"PICK_LAST_CMPD_DPTR_DTT", type date}, {"SHPM_DROP", Int64.Type}, {"DROP_CMPD_ARVL_DTT", type date}, {"DROP_CMPD_DPTR_DTT", type date}, {"DROP_ARVL_RPTD_DTT", type date}, {"DROP_LAST_CMPD_ARVL_DTT", type date}, {"DROP_LAST_CMPD_DPTR_DTT", type date}, {"DOM_INT", type text}, {"BU", type text}, {"ICD_CUTOMER", type text}, {"SHPM_TYPE", type text}, {"SHPM_SCENARIO", type text}, {"BS_WGT_RANGE", type text}, {"TO_DLVY_DTT", type date}}),

#"Removed Blank Rows" = Table.SelectRows(

#"Tipo cambiado", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))) in

#"Removed Blank Rows"

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

I tried the latest version of power bi desktop but cannot reproduce the issue. Try to recreate the report.