- 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
Need Max value month wise from last 2 years selected from the slicer
Hi All,
I want maximum Value in each month from last 2 year comparison. Kindly help me if data is like below
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
write the following measure :
(this will take into consideration current year and previous year )
m =
var currentyear = year ( today() )
var ds =
filter (
tbl_name , year >= currentyear - 1 )
RETURN
maxx( ds , value )
NB: if you want to take only prev 2 years excluding the current year, change the filter to this :
var ds =
filter (
tbl_name , year >= currentyear - 2 && year < currentyear )
tbl_name being the table containing your data, and value being the column name with the values you want to display .
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Anonymous please create below measure
Max Value = CALCULATE(MAXX('Table','Table'[Value]),ALLEXCEPT('Table','Table'[Month]))
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
- 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
Hello @Anonymous please create below measure
Max Value = CALCULATE(MAXX('Table','Table'[Value]),ALLEXCEPT('Table','Table'[Month]))
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
write the following measure :
(this will take into consideration current year and previous year )
m =
var currentyear = year ( today() )
var ds =
filter (
tbl_name , year >= currentyear - 1 )
RETURN
maxx( ds , value )
NB: if you want to take only prev 2 years excluding the current year, change the filter to this :
var ds =
filter (
tbl_name , year >= currentyear - 2 && year < currentyear )
tbl_name being the table containing your data, and value being the column name with the values you want to display .
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
01-08-2024 08:00 AM | |||
01-19-2024 12:44 PM | |||
06-06-2024 09:28 AM | |||
08-12-2024 10:56 AM | |||
06-18-2024 11:30 PM |
User | Count |
---|---|
123 | |
79 | |
59 | |
58 | |
44 |
User | Count |
---|---|
179 | |
120 | |
82 | |
70 | |
53 |