Forum Discussion
dusdau
Helper II
Helper IICounting 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...
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!
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.
dusdauHelper II
Helper IIOk, 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!