- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Record only display last 3 years (complete cycles) value
Hi.
I have created a sample table below for reference.
I need to create a line chart. How can I create a measure to only display the last 3 years of records (complete cycles) from the current year?
Thank you in advance.
Regards,
NickzNickz
.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @AjithPrasath ,
Based on your input and the available samples, I create the measure below to get the value.
Last 3 Years =
VAR _currentyear = YEAR(TODAY())
VAR _previousyear = SELECTEDVALUE(test_last3years[Year])
RETURN
SWITCH(
TRUE(),
_previousyear <= _currentyear -1 &&
_previousyear >= _currentyear -3,1,
0
)
Regards,
NickzNickz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @NickzNickz ,
create a measure to determine the current year. You can use the TODAY() function to get the current date and extract the year from it
Current Year = YEAR(TODAY())
Now, create a measure that calculates the last 3 years from the current year. Let's name this measure "Last 3 Years"
Last 3 Years = IF([Year] >= [Current Year] - 3 && [Year] <= [Current Year], 1, 0)
Finally, use the "Last 3 Years" measure as a filter in your line chart visual. Set the filter to include only the records where the measure evaluates to 1.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have successfully created the measure for Year.
For measure #2, how can I get the column [Year] .... ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For that, use the year column in your table===> 'Tablename'[year]
If I answered your question, please mark my post as solution, Appreciate your Kudos
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @AjithPrasath ,
Based on your input and the available samples, I create the measure below to get the value.
Last 3 Years =
VAR _currentyear = YEAR(TODAY())
VAR _previousyear = SELECTEDVALUE(test_last3years[Year])
RETURN
SWITCH(
TRUE(),
_previousyear <= _currentyear -1 &&
_previousyear >= _currentyear -3,1,
0
)
Regards,
NickzNickz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
IF you want to use simplified code , you can use the below code :
Last 3 Years =
VAR _currentyear = YEAR(TODAY())
VAR _previousyear = SELECTEDVALUE(test_last3years[Year])
RETURN
IF(_previousyear >= _currentyear - 3 && _previousyear <= _currentyear - 1, 1, 0)
If you got your answer, please mark this as answer and give kudos
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-27-2025 06:11 PM | |||
04-07-2025 08:45 AM | |||
03-19-2025 11:36 AM | |||
03-01-2023 02:43 AM | |||
05-12-2025 11:32 AM |
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |