topic Re: Using Datediff to find records in this year in DAX Commands and Tips

Using Datediff to find records in this year

craigL01 — Mon, 12 Feb 2024 11:59:50 GMT

I have this DAX code

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

its only returning records dated this month

any ideas

ValtteriN — Mon, 12 Feb 2024 12:26:55 GMT

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 — Mon, 12 Feb 2024 12:54:07 GMT

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 — Wed, 14 Feb 2024 11:34:06 GMT

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/