Forum Discussion
Display Data for two years based on Year filter
Hello again lovishsood1 ,
I appreciate your follow-up.
Since you’re working exclusively with the Year column and don’t have a full date table, there’s no need for time-intelligence functions. You can achieve your goal efficiently with a straightforward DAX filter, like this:ShowTwoYearsData =
VAR SelectedYear = SELECTEDVALUE('AcademicData'[Year])
RETURN
CALCULATE(
[YourMetric],
FILTER(
'AcademicData',
'AcademicData'[Year] IN { SelectedYear, SelectedYear - 1 }
)
)This measure will accurately return results for the selected year and the previous year. You can use it directly in your visual, and it will function correctly even without a date table.
If you decide to expand to months or quarters in the future, implementing a proper Date table will be beneficial. For now, this year-based approach is the most effective solution for your requirements.
Thak you.
Hii, can you help me with the below query of year
Can you tell me How to make a year measure which shoudl have condition like even if the data doest not have value for all month like all 12 month then also the whole 12 month ka value should show by taking some of the month from previous year to complete the 12 month sereies with cureent year.
FOR eg: for year 2025 my data has the value only for three month like jan,feb and march. and year 2024 have all jan to dec okay
so in my matric visual i want the result to shown as
apr-24 may -24, jun-24, july-24 ......nov-24, dec-24, jan-25, feb-25,mar-25
I hope from the above kidn of example you get my question, so it should be like that much dynmich thta if 2025 get any new month added to data then accoridng it should show from prevoiud year till current year by considering of 12 month series
You can use the Filter Pane - Drag the Date column and set it to Last 12 months