Today funtion

[Anonymous]

Hi

Can someone please tell me what the today part do in this colum formula: 

On time order =
IF (
    'Orders'[CANTIDADFACTURA] <> BLANK (),
    IF (
        'Orders'[CANTIDAD PEDIDO] <= 'Orders'[CANTIDADFACTURA],
        "Sí",
        "No"
    ),
    IF (
        'Orders'[VALOR PEDIDO] = 0,
        BLANK (),
        IF (
            'Orders'[FECHAHORAENTREGA] < TODAY (),
            "No",
            BLANK ()
        )
    )
)

The colums: 

[CANTIDADFACTURA] : Quantity of billed itmes

[CANTIDAD PEDIDO]: Quantity of order itmes

[VALOR PEDIDO]: Quantity or order items in dollars

[FECHAHORAENTREGA]: Date and hour of delivery

Thanks!

[Phil_Seamark · Accepted solution]

Hi @Anonymous

The DAX function TODAY, simply returns the current date.  For example, this might be the 28th of May, 2018.  This is dynamic so tomorrow it will be the 29th May, 2018.

In your calculation, the IF function is just testing each value in your 'Orders'[FECHAHORAENTREGA] column to see if it happens to be in the past, or in the future.