Using Datediff to find records in this year

[craigL01]

I have this DAX code

filter(MYTABLE,DATEDIFF(MYTABLE[MYDATEFIELD],today(),YEAR)=0))

its only returning records dated this month

any ideas

[ValtteriN]

Hi,

The logic should work, e.g. here is my test:

How are you using your dax? Consider if some other filter affects the table. Also here is an alternative:

Calendar filtered = FILTER('Calendar',YEAR('Calendar'[Date])=YEAR(TODAY()))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[craigL01]

im using it as a measure

heres the full code

AUKNPSCardsIssuedThisYear = CALCULATE(

    count(PROJTABLE[PROJID]),

    Filter(PROJTABLE,PROJTABLE[AUKInstallStatus] = "Installed (full)"),

    filter(PROJTABLE,DATEDIFF(PROJTABLE[MXMPROJESTIMATEDENDDATE],today(),YEAR)=0))

[ValtteriN]

Hi,

I recommend using this kind of measure:

Data:

Here let's imagine status A = Installed (full).

The end result should be 2.

Dax:

Measure 15 = CALCULATE(COUNT('Table (23)'[ID]),'Table (23)'[Status]="A",YEAR('Table (23)'[Date])=YEAR(TODAY()))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/