Reply
Topic Options
- 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
Value for previous month without blank
07-12-2024
07:15 AM
Hi,
I wrote a measure where I want to retrieve the value of the previous month without taking the group into account. However, everything I test takes the group into account. Does someone have an idea ?
My values :
Date | Group | Value |
202401 | A | 10 |
202402 | A | 10 |
202403 | A | 10 |
202404 | B | 15 |
202405 | B | 15 |
202406 | B | 15 |
202407 | B | 20 |
202408 | B | 20 |
My measure :
Previous Mth = CALCULATE([Value],PREVIOUSMONTH(Calendar[Date]))
My results :
Date | Group | Value | Previous Month |
202401 | A | 10 | |
202402 | A | 10 | 10 |
202403 | A | 10 | 10 |
202404 | A | 10 | |
202404 | B | 15 | |
202405 | B | 15 | 15 |
202406 | B | 15 | 15 |
202407 | B | 20 | 15 |
202408 | B | 20 | 20 |
What i looking for ..
Date | Group | Value | Previous Month |
202401 | A | 10 | |
202402 | A | 10 | 10 |
202403 | A | 10 | 10 |
202404 | B | 15 | 10 |
202405 | B | 15 | 15 |
202406 | B | 15 | 15 |
202407 | B | 20 | 15 |
202408 | B | 20 | 20 |
Thanks for your help !
Guillaume
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2024
08:27 AM
If you will use this in only one visual you can leverage from visual calculations and use the PREVIOUS() function from it.
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a Super User!
2 REPLIES 2
- 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
Recommendations
Subject | Author | Posted | |
---|---|---|---|
08-19-2024 08:47 AM | |||
06-13-2023 01:59 AM | |||
07-10-2024 03:57 AM | |||
08-30-2024 11:11 AM | |||
Anonymous
| 10-14-2022 04:32 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |