Forum Discussion

Meng's avatar
Meng
Advocate II
5 years ago
Solved

DATEADD return blank

Hi,   Question1:   I need to count customer number of last one year ,also the last two year, while I find it will get the same result data when I used the DAX below, while in fact, the data shoul...
  • Meng's avatar
    5 years ago

    Finally, I put the Year of Date[Date] into column box of Matrix visua, it will return the data in last Year and in last two Year according to related years. it seems to mean that the Date must also be added into visual when use Time Intelligence function such as DATEADD.