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