Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |