Forum Discussion
DAX
Hi everyone, I have 2 tables: ID_STEP STEP GOAL 1 A 10 2 B 12 3 C 15 4 D 5 AND: ITEM ID_STEP STEP DURATION 1111 1 A 5 1111 2 B 10 1111 3 C...
what is the ACTUAL_STEP at the last table?
Hasan It is the STEP in which the ITEM is currently, it is the actual row. This field is the same ID_STEP, and I need get the Goal for this STEP and the total sum of field DURATION.
Thanks!!
The last table is an example, is a matrix in wich i want to get the values when, for example, i filter by the ITEM = 2222 in the STEP = 1, etc. This is another example for the ITEM 2222:
ITEM STEP GOAL DURATION 2222 1 10 26 2222 2 12 10 2222 3 15 15 2222 4 5 20 I only need to calculate de red fields, using DAX measures.
Thanks!!
