Forum Discussion

ajbogle's avatar
ajbogle
Helper I
3 years ago
Solved

First Date based on Column Type

Hello,   The subject is essentially what I am after and I feel like I am 90% of the way there but when I click on a Calender Month/Year it changes my desired results.   Redesign Customer =     ...
Need Help
  • ajbogle's avatar
    ajbogle
    3 years ago

    I've tried adding ALL into the redesign variable but still changes the date unfortuantely. And I got the Total Duration figured out, instead of summarizing over [Design Approved] I did it over the Primary Key which is RID and that resolved that issue.

danextian's avatar
danextian
Super User
3 years ago

Hi ajbogle ,

 

You can add another argument to your existing formula. That should be something like:

Redesign Customer =
CALCULATE (
    MIN ( 'SLA: Design'[Design Queued] ),
    ALLEXCEPT ( 'SLA: Design', 'SLA: Design'[RID] ),
    ALL ( 'SLA: Design'[Record ID #] ),
    'SLA: Design'[Type] = "Redesign: Customer"
)

 

For the duration, how do you calculate it? It appers it is being averaged (29/2 = 14.5)

 

  • ajbogle's avatar
    ajbogle
    Helper I
    3 years ago

    I've tried adding ALL into the redesign variable but still changes the date unfortuantely. And I got the Total Duration figured out, instead of summarizing over [Design Approved] I did it over the Primary Key which is RID and that resolved that issue.