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)

2 Replies

  • 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)