Showing last 12 months which have data

[srdirect]

hi looking for some direction in using some of the time intelligence functions.....

I am trying to create a measure which will show the my last 12 months where I have have data for my measure
[I aggregated multiple tables into a measure]

just cant seem to figure out how to use the time intelligence functions to show the

 

[scottsen]

For this sort of thing I usually add a calculated column to my calendar table (IsRecent12Mo or whatever) then use that as a filter.

 

[srdirect]

But I want to tie it to recent data and not the last 12 months,
for example I might only have data until march of this year, and wish to get 12 months from then)

 

[scottsen]

So, your fact/data table... that has sales until march, it has some sort of date column, right? MAX(Sales[Date]) is going to give the last date there.

Over in your calendar table, you can do something a calculated column:
=IF(Calendar[Date] <= MAX(Sales[Date]) &&
MAX(Sales[Date]) - Calendar[Date] < 365, "Current", "Old")

Might not be perfect, but hopefully you get the idea. You then have a column in your calendar table that you can use for filtering... wherever.

 

[srdirect]

Awesome it worked
many thanks!!!