DATEADD DAX / Issue

[Juju78]

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. 

[Dangar332 · Accepted solution]

Hi, @Juju78 

try below

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

[Dangar332]

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

[mohitkumawat]

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.

[mohitkumawat]

can you attached a sample file with dummy data 
thanks 

[Juju78]

Hi @mohitkumawat 
Thanks a lot, unfortunately it doesnt seem to work either : 

[mohitkumawat]

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!!