Forum Discussion
DAX Measure
I have Project Table, some necessary columns are given below: Project Case Organization StartPeriod EndPeriod 42251 XYZ 8/27/2017 10/16/2017 I have another table Tickets, which lo...
Anonymous so as I understand, Measure1 is working as intended but Measure2 is not with the revised dataset.
Try this out
Measure2 = VAR _0 = CALCULATE ( MAX ( Project[EndPeriod] ), FILTER ( VALUES ( Project[Organization] ), Project[Organization] = CALCULATE ( MAX ( Tickets[Organization] ) ) ) ) VAR _1 = CALCULATE ( COUNT ( Tickets[Case] ), FILTER ( Tickets, Tickets[StartPeriod] > _0 && Tickets[StartPeriod] <= _0 + 30 ) ) RETURN _1
Anonymous my solutuion was based on the data provided.
Improve your question with better sample data if you are not getting the result you desire.
smpa01 I just updated the dates for the case
Project Table
| Project case | Organization | StartPeriod | EndPeriod |
| 42251 | XYZ | 8/6/2017 | 8/31/2017 |
Tickets Table
| Case | Organization | StartPeriod | EndPeriod |
| 52454 | XYZ | 8/28/2017 | 9/6/2017 |
| 56464 | XYZ | 9/6/2017 | 9/18/2017 |
| 54859 | XYZ | 9/7/2017 | 9/26/2017 |
| 52421 | XYZ | 9/8/2017 | 9/9/2017 |
Here, when you look at the dates. The project case for Organization XYZ was started and completed in August on 8/31/2017.
For Measure 2, I want the cases from Tickets Table where the StartPeriod is after 8/31/2017 for first 30 days (i.e from 9/1/2017 to 9/30/2017)
Makes Sense?
Any recommendations Greg_Deckler amitchandak