Forum Discussion

Artofdax's avatar
Artofdax
Frequent Visitor
2 years ago
Solved

Datediff with % off

hi, need little help with my calculation.   I would like to take 20% off Target Days   DATEDIFF(Table1[First Day)],Table1[Last Day)],DAY)<=(Table1[Target Days])
Need Help
  • aduguid's avatar
    aduguid
    2 years ago

    Try this measure 

    DaysDifferenceCheck =
DATEDIFF(Table1[First Day], Table1[Last Day], DAY) <= (Table1[Target Days] * 0.8)
aduguid's avatar
aduguid
Memorable Member
2 years ago

Try this measure 

DaysDifferenceCheck =
DATEDIFF(Table1[First Day], Table1[Last Day], DAY) <= (Table1[Target Days] * 0.8)
Artofdax's avatar
Artofdax
Frequent Visitor
2 years ago

Thank you