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.
Hello everyone,
I need help calculating the lead time between two steps of each specific order in front of that step using a calculated column or a measure.
Thanks in advance
Solved! Go to Solution.
My bad, that should have been:
calc column =
CALCULATE (
MAX ( table[Date] ),
FILTER ( ALL ( table[Step] ), table[Step] = "C" ),
ALLEXCEPT ( table, table[order] )
)
- CALCULATE (
MAX ( table[Date] ),
FILTER ( ALL ( table[Step] ), table[Step] = "A" ),
ALLEXCEPT ( table, table[order] )
)
or
calc column =
CALCULATE (
MAX ( table[Date] ),
table[Step] = "C",
ALLEXCEPT ( table, table[order] )
)
- CALCULATE (
MAX ( table[Date] ),
table[Step] = "A",
ALLEXCEPT ( table, table[order] )
)
Proud to be a Super User!
Try something like:
calc column =
CALCULATE (
MAX ( table[Date] ),
ALL ( table[Step] ) = "C",
ALLEXCEPT ( table, table[order] )
)
- CALCULATE (
MAX ( table[Date] ),
ALL ( table[Step] ) = "A",
ALLEXCEPT ( table, table[order] )
)
The same logic can be used for the other step.
Proud to be a Super User!
Thanx @danextian
It errors for
ALL ( table[Step] ) = "C"
>> The True/False expression does not specify a column. Each True/False expression used as a table filter expression must refer to exactly one column.
- I changed it to this:
calc_column =
CALCULATE (
MAX (ordertable[Date]),
FILTER(Ordertable,Ordertable[Step] = "C"),
GROUPBY(Ordertable,Ordertable[Order No])
)
-
CALCULATE (
MAX (ordertable[Date]),
FILTER(Ordertable,Ordertable[Step] = "A"),
GROUPBY(Ordertable,Ordertable[Order No])
)
but it results in this:
My bad, that should have been:
calc column =
CALCULATE (
MAX ( table[Date] ),
FILTER ( ALL ( table[Step] ), table[Step] = "C" ),
ALLEXCEPT ( table, table[order] )
)
- CALCULATE (
MAX ( table[Date] ),
FILTER ( ALL ( table[Step] ), table[Step] = "A" ),
ALLEXCEPT ( table, table[order] )
)
or
calc column =
CALCULATE (
MAX ( table[Date] ),
table[Step] = "C",
ALLEXCEPT ( table, table[order] )
)
- CALCULATE (
MAX ( table[Date] ),
table[Step] = "A",
ALLEXCEPT ( table, table[order] )
)
Proud to be a Super User!
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |