Matrix Rows Filter By Date

[dday9]

Currently I have a data table with several DateTimeOffset columns, what I'm wanting to do is create a matrix that displays the count of the respective columns based on a date range. What I'm envisioning is having my date range displayed as the rows and then the count of my columns as the values. Below is a screenshot of what I'm trying to accomplish:

Where I'm running into an issue is that if I attempt to add a column with my desired date range, Power BI gives an error stating that the first argument of DATEADD needs to be a column:

NintyDaysAgo = DATEADD(TODAY(), 90, DAY)

[Greg_Deckler · Accepted solution]

Forget DATEADD, just do TODAY() + 90. Date is a decimal. The whole number portion is the number of days. The decimal is the time. So, adding a date and a whole number gives you date that is +/- that many "days".

[pbeye]

Have you tried creating a new column that's just TODAY()? You should be able to use that in your formula.

today = today()