Forum Discussion
DAX Filter
Anonymous
No worries. I'm learning just like you.
To clarify, you CAN create CC's (Calculated Columns) in the 'Times' table.
I was simply saying that the result won't look like your screenshot of desired results.
- Your desired result screenshot presents 5 rows of data on only 3 rows (Grouping By Order No. & Milestone)
- The data table 'Times' does not group because it's a data table.
Regardless, below is how to create the CC's:
NOTE: When creating multiple CC's in the same table (which use CALCULATE), this creates a Circular Dependency. To get around this you have to use ALLEXCEPT.
Here is the data view of the 'Times' table along with the 2 added CC's.
Hope this is helpful to you.
Nathan
Impactful IndividualAnonymous
No worries. I'm learning just like you.
To clarify, you CAN create CC's (Calculated Columns) in the 'Times' table.
I was simply saying that the result won't look like your screenshot of desired results.
- Your desired result screenshot presents 5 rows of data on only 3 rows (Grouping By Order No. & Milestone)
- The data table 'Times' does not group because it's a data table.
Regardless, below is how to create the CC's:
NOTE: When creating multiple CC's in the same table (which use CALCULATE), this creates a Circular Dependency. To get around this you have to use ALLEXCEPT.
Here is the data view of the 'Times' table along with the 2 added CC's.
Hope this is helpful to you.
Nathan
I have implemented your code which has no errors but still fails to produce the desired code (still producing blanks despite valid data). I think the issue may not even be the code since you achieve the desired result yourself? I have attached the Times table (top) and Output table (bottom). Cheers