Forum Discussion

Juju78's avatar
Juju78
New Member
2 years ago
Solved

DATEADD DAX / Issue

Hello,

I am struggling since few hours with the DATEADD formula. 
Here my usecases : I would like to compare the number of articles producted between 2022 and 2023.
I have 2 columns in my Tab calls "WebxCRM" with : "publication date", and "Title" (see an extract below).

I have created a quick measure allowing to calculate the number of article created per month (this formula is working):

Total articles all = COUNT(WebxCRM[Title])

 

Also, I have created a measure in order to calculate the evolution between 2022/2023.
Total articles y-1 = CALCULATE([Total articles all], DATEADD('WebxCRM'[Publicationdate],-1,YEAR))

But As you can see below, this is not working, the column "total articles y-1" is empty. I have no idea of why. I am trying to fix this since hours.



Many thanks for your help. 
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, Juju78 

    try below

    Total articles y-1 = 
CALCULATE([Total articles all], DATEADD('WebxCRM'[Publicationdate],-1,YEAR),
            removefilters(tablename[nombre de title])
          )

6 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    Hi, Juju78 

    try below

    Total articles y-1 = 
CALCULATE([Total articles all], DATEADD('WebxCRM'[Publicationdate],-1,YEAR),
            removefilters(tablename[nombre de title])
          )
  • mohitkumawat's avatar
    mohitkumawat
    Impactful Individual
    2 years ago

    Hi Juju78 ,

    try using  the SamePeriodLastYear() function instead of using DATEADD().


    If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

  • mohitkumawat's avatar
    mohitkumawat
    Impactful Individual
    2 years ago

    Hi Juju78 

    Try below Measure if it works 
    Last Year = CALCULATE(count(WebxCRM[Title]),SAMEPERIODLASTYEAR('WebxCRM'[Publicationdate]))

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.



  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    Hi, Juju78 

    try below

     

    total artical Y-1 =
calculate(
 [total articales all], 
  filter(
    tablename,
    tablename[yearcolumn]<= max(tablename[yearcolumn])&&
     tablename[yearcolumn]>=max(tablename[yearcolumn])-1
  ),
 allexcept(tablename,tablename[yearcolumn])
)