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 call...
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])
          )
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!!