Forum Discussion

MiaZhao's avatar
MiaZhao
Helper I
8 years ago
Solved

whether in the same day

Hi Everyone,

 

How to tell whether the events happened on the same day or not? I would like to return column isSame.

NameDateisSame
Ann1/1/2018FALSE
Ann1/2/2018FALSE
Mary1/2/2018TRUE
Mary1/2/2018TRUE

 

Thanks.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Try this

     

    IsSame = IF('Table-Test'[Date]=CALCULATE(AVERAGE('Table-Test'[Date]),ALLEXCEPT('Table-Test','Table-Test'[Name])),true)

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Try this

     

    IsSame = IF('Table-Test'[Date]=CALCULATE(AVERAGE('Table-Test'[Date]),ALLEXCEPT('Table-Test','Table-Test'[Name])),true)