Forum Discussion

Jabbajuice's avatar
Jabbajuice
Frequent Visitor
4 years ago
Solved

DAX Calculated Column- comparing date column based on filtering from two other columns

I'm not sure how to word the issue I'm having, but I'll try.    So basically I have Hardware name, start date, finish date, and review type as column names for scheduling data. There can be multipl...
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Jabbajuice 

    Thanks for reaching out to us.

    You can try this column 

    Column = 
var _a="Test product"
var _cr=CALCULATE(MAX('Table'[Start Date]),FILTER( ALLEXCEPT('Table','Table'[Hardware Name]),'Table'[Review Type]="Critical Review"))
var _pb=CALCULATE(MAX('Table'[Start Date]),FILTER( ALLEXCEPT('Table','Table'[Hardware Name]),'Table'[Review Type]="Product Build"))
return IF('Table'[Start Date]>_cr && 'Table'[Start Date]<_pb,_a,'Table'[Review Type])

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Jabbajuice 

Thanks for reaching out to us.

You can try this column 

Column = 
var _a="Test product"
var _cr=CALCULATE(MAX('Table'[Start Date]),FILTER( ALLEXCEPT('Table','Table'[Hardware Name]),'Table'[Review Type]="Critical Review"))
var _pb=CALCULATE(MAX('Table'[Start Date]),FILTER( ALLEXCEPT('Table','Table'[Hardware Name]),'Table'[Review Type]="Product Build"))
return IF('Table'[Start Date]>_cr && 'Table'[Start Date]<_pb,_a,'Table'[Review Type])

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.