Forum Discussion

tejapowerbi123's avatar
tejapowerbi123
Icon for Helper V rankHelper V
6 years ago
Solved

Date difference based on condition

Hello Community, Can you please provide your suggestion? I have two tables and they both have one to one relationship.My requirements is that I want to match ID on both table and if ID will match t...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi tejapowerbi123 , 

    You could try below measure and refer to my sample for details

    Measure 2 = IF(MIN(TA[ID])=MIN(TB[ID]), DATEDIFF(MIN(TA[DATE]), MIN(TB[DATE]), DAY), BLANK())

     

    Best Regards,
    Zoe Zhi

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

tejapowerbi123's avatar
tejapowerbi123
Icon for Helper V rankHelper V
6 years ago

if id column match on table a and table then i want table a [date]-table b [date].That is the logic.

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi tejapowerbi123 , 

You could try below measure and refer to my sample for details

Measure 2 = IF(MIN(TA[ID])=MIN(TB[ID]), DATEDIFF(MIN(TA[DATE]), MIN(TB[DATE]), DAY), BLANK())

 

Best Regards,
Zoe Zhi

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