Forum Discussion

dusdau's avatar
dusdau
Icon for Helper II rankHelper II
8 years ago
Solved

Counting rows where date column falls within the last year

Hi All,   DAX newbie here, trying to do what seems like it should be a simple measure.  I have a table ('Market Share') that has a column of dates (LastModified), which has a relationship to my dat...
Need Help
  • dusdau's avatar
    dusdau
    8 years ago

    Ok, it wasn't the null values.  I think it was an issue with Date/Time format of the column.  I changed both the Market Share table and the Date table to 'Date' and it works.  Thanks for your help Ross!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

The nulls shouldn't matter that much.  Your column is set to type "Date" isnt it?

dusdau's avatar
dusdau
Icon for Helper II rankHelper II
8 years ago

Interestingly the column or nulls seems to have an issue.   It is definitely a Date/Time column.

 

I created another column with formula (TodayDate = TODAY()-325) and then changed the relationship to the date table, and the formula works.

 

Not quite sure how to deal with the NULLs yet...

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Good info to know!  Glad you are getting closer.  You are on the right track.  A find/replace of nulls to a specific date could be your solution. Whether that date is done via a lookup, or as a set "filter me out" type date will depend on your needs.

    • dusdau's avatar
      dusdau
      Icon for Helper II rankHelper II
      8 years ago

      Ok, it wasn't the null values.  I think it was an issue with Date/Time format of the column.  I changed both the Market Share table and the Date table to 'Date' and it works.  Thanks for your help Ross!