Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can't update my Power BI due to error: Too few arguments were passed for the sum function
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.