Estimados expertos
Hice un reordenamiento para las columnas basado en el estándar de negocios para mi organización, lo hice con éxito en Power bi a través del editor de consultas, luego cuando voy a DAX studio para escribirlo como formato (csv) lo encontré alfabéticamente (entiendo que esto es natural), después de escribir el archivo a través de Dax Studio cuando abro el archivo encuentro la columna ordenando no como la que hice en power bi query editor. El tamaño del archivo es grande (3 GB) no se puede abrir en excel para reordenarlo, debajo de la muestra de archivo MDAX de las columnas como lo quiero, ¿puede alguien guiarme cómo resolver este problema?
El código MDAX:
#"Columnas reordenadas" = Table.ReorderColumns(#"Columnas eliminadas",{"order_id","cantidad", "unit_price","returned_quantity","tax_exclusive_discount_amount_order_dt", "total_price_order_dt", "tax_exclusive_unit_price", "tax_exclusive_total_price", "void_reason","combo","combo_option_size","product_id", "is_ingredients_wasted","total_cost","sum_taxes_pivot_amount","sum_options_total_cost","sum_optional_taxes_pivot_amount", "status_detail", "promoción", "original_order", "mesa", "conductor", "cliente", "customer_address", "descuento", "cupón", "gift_card", "app_id", "promotion_id", "discount_type", "reference_x", "número", "tipo", "fuente", "estado", "delivery_status", "invitados", "kitchen_notes", "customer_notes", "business_date", "subtotal_price", "discount_amount", "rounding_amount", "precio total", "tax_exclusive_discount_amount", "delay_in_seconds", "opened_at", "due_at", "driver_assigned_at", "driver_collected_at", "closed_at", "created_at", "updated_at", "referencia", "check_number", "branch_count", "table_count", "creator_count", "closer_count", "driver_count", "customer_address_count", "discount_count", "coupon_count", "tags_count", "promotion_count", "charges_count", "payments_count", "gift_card_count", "combos_count", "products_count", "original_order_count", "branch_id", "creator_id", "closer_id", "device_id", "customer_id", "customer_address_id", "discount_id", "coupon_id", "original_order_id", "más cerca", "creador", "meta", "accepted_at", "dispatched_at", "delivered_at", "customer_count", "device_count", "payment_method_id_1" })
