Why are DATEADD(), EndOfMonth(), StartOfMonth() not to be used?

[Anonymous]

Hi,

The attached image is from the well known and respected Jeffrey Wang (Microsoft Power BI Engineering Manager) .
Why is the use of "DateAdd(), EndOfMonth(), StartOfMonth()" wrong? Why is EOMonth() good and EndOfMonth() bad?

The URL of JW's presentation can be found below:
https://www.dropbox.com/sh/yhop1c7c8sdod5f/AAC0iTm1206-donIgEC3Ry0Ya?dl=0
(Inside Aug 2017 folder)

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

When we use the DateAdd/EndOfMonth/StartOfMonth function, we need  use column inside, but the EOMoth/EDate can accept single datetime value and Today function will only return one value.

So In your scenario, we cannot use DateAdd/EndOfMonth/StartOfMonth function with the Today function.

Best regards,

[MFelix]

Hi @Anonymous ,

Believe that the answer is given on the previous slide of the presentation where you have taken out the image: