---
type: work
area: work
status: active
date: 2026-05-03
created: 2026-05-03
updated: 1980-01-01
tags:
  - work
---
For my project execution steps its composed by multiple steps :
- Querying :  I run a query against the semantic model to retrieve data from it. It gives me a 35 columns and +500K row as result 
``` dax
DEFINE  
    VAR __DS0FilterTable =  
        FILTER (  
            KEEPFILTERS ( VALUES ( 'Billing Cases'[ProcessingDate] ) ),  
            AND (  
                'Billing Cases'[ProcessingDate] >= DATE ( {year}, {month}, {day_start} ),  
                'Billing Cases'[ProcessingDate] <= DATE ( {year}, {month}, {day_end} )  
            )  
        )  
    VAR __DS0Core =  
        FILTER (  
            KEEPFILTERS (  
                SUMMARIZECOLUMNS (  
                    'Transport Orders'[ChargedLocationName],  
                    'Transport Orders'[ServiceLevel],  
                    'Billing Cases'[ProcessingDate],  
                    'Billing Cases - Costs'[BillIdExternalDate],  
                    'Billing Cases - Costs'[CostType],  
                    'Billing Cases'[LoadId],  
                    'Billing Cases'[TransportOrderId],  
                    'Billing Cases'[SteeringPartnerId],  
                    'Billing Cases'[SteeringPartnerName],  
                    'Billing Cases'[BillingCaseId],  
                    'Transport Orders'[BusinessCase],  
                    'Transport Orders'[SupplierName],  
                    'Billing Cases'[BillingPartnerName],  
                    'Transport Orders'[PickupLocationID],  
                    'Transport Orders'[PickupLocationCity],  
                    'Transport Orders'[PickupLocationZipCode],  
                    'Transport Orders'[PickupLocationCountry],  
                    'Transport Orders'[ChargedLocationId],  
                    'Transport Orders'[Scope],  
                    'Transport Orders'[PlantName],  
                    'Transport Orders'[DeliveryLocationCity],  
                    'Transport Orders'[DeliveryLocationID],  
                    'Transport Orders'[DeliveryLocationZipCode],  
                    'Transport Orders'[DeliveryLocationCountry],  
                    'Billing Cases - Costs'[BillIdExternal],  
                    'Transport Orders'[Department Description],  
                    'Loads'[SourcingRegion],  
                    'Loads'[TransportMode],  
                    'Billing Cases'[CodeI],  
                    'Billing Cases'[CostCenter],  
                    'Billing Cases'[Gl Account],  
                    'Billing Cases'[Indicator],  
                    'Rating Units'[ProcessingDate],  
                    __DS0FilterTable,  
                    "SumAmountInEuro", CALCULATE ( SUM ( 'Billing Cases - Costs'[AmountInEuro] ) ),  
                    "MaxCurrentStatus", CALCULATE ( MAX ( 'Billing Cases - Costs Status (selection)'[CurrentStatus] ) )  
                )  
            ),  
            [SumAmountInEuro] <> 0  
        )  
  
EVALUATE  
__DS0Core  
ORDER BY  
    'Transport Orders'[ServiceLevel] DESC,  
    'Transport Orders'[ChargedLocationName],  
    'Billing Cases'[ProcessingDate],  
    'Billing Cases - Costs'[BillIdExternalDate],  
    'Billing Cases - Costs'[CostType],  
    'Billing Cases'[LoadId],  
    'Billing Cases'[TransportOrderId],  
    'Billing Cases'[SteeringPartnerId],  
    'Billing Cases'[SteeringPartnerName],  
    'Billing Cases'[BillingCaseId],  
    'Transport Orders'[BusinessCase],  
    'Transport Orders'[SupplierName],  
    'Billing Cases'[BillingPartnerName],  
    'Transport Orders'[PickupLocationID],  
    'Transport Orders'[PickupLocationCity],  
    'Transport Orders'[PickupLocationZipCode],  
    'Transport Orders'[PickupLocationCountry],  
    'Transport Orders'[ChargedLocationId],  
    'Transport Orders'[Scope],  
    'Transport Orders'[PlantName],  
    'Transport Orders'[DeliveryLocationCity],  
    'Transport Orders'[DeliveryLocationID],  
    'Transport Orders'[DeliveryLocationZipCode],  
    'Transport Orders'[DeliveryLocationCountry],  
    'Billing Cases - Costs'[BillIdExternal],  
    'Transport Orders'[Department Description],  
    'Loads'[SourcingRegion],  
    'Loads'[TransportMode],  
    'Billing Cases'[CodeI],  
    'Billing Cases'[CostCenter],  
    'Billing Cases'[Gl Account],  
    'Billing Cases'[Indicator],  
    'Rating Units'[ProcessingDate]
```

- Converting : Convert this result from Dot Net Table to NumPy array because I'm using pyadomd library.
- Export : Export to various data format (CSV, EXCEL, Parquet) in séquentiel way i noticed that EXCEL take a long time
- Validation : I run a dax query against the model that retrieves the sum of column called 'Billing Cases - Costs'[AmountInEuro] and compare it to the sum of this column but based on data that stored on dataframe exported with the first query
```dax
DEFINE  
    VAR __DS0FilterTable =  
        FILTER (  
            KEEPFILTERS ( VALUES ( 'Billing Cases'[ProcessingDate] ) ),  
            AND (  
                'Billing Cases'[ProcessingDate] >= DATE ( {year}, {month}, {day_start} ),  
                'Billing Cases'[ProcessingDate]  
                    <= ( DATE ( {year}, {month}, {day_end} ) + TIME ( 0, 0, 1 ) )  
            )  
        )  
  
EVALUATE  
SUMMARIZECOLUMNS (  
    __DS0FilterTable,  
    "SumAmountInEuro", IGNORE ( CALCULATE ( SUM ( 'Billing Cases - Costs'[AmountInEuro] ) ) )  
)
```