- 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

How to show value for all months between begin and end date
Hi all'ya.
Data comes in as follows:
Project name, beginning date for billing, end date for billing, total sum and monthly revenue. Each of these is their own field. How do I show on the report that, e.g. billing that started March and ended in May shows values for all these three months?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
I suggest you to create an unrelated calendar table and add a measure to filter the visual.
Data model:
Measure:
Filter =
VAR _RANGESTART =
MIN ( 'Calendar'[Date] )
VAR _RANGEEND =
MAX ( 'Calendar'[Date] )
RETURN
IF (
MAX ( 'Table'[beginning date for billing] ) >= _RANGESTART
&& MAX ( 'Table'[end date for billing] ) <= _RANGEEND,
1,
0
)
Add this measure into visual level filter and set it to show items when value =1.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Problem is, I want to show the months between - not just amount of months or the first and the last. But I want to list all the months between.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes, thank you so much. I'll look at this with more thought tomorrow.

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!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
05-21-2024 07:42 AM | |||
03-22-2023 07:08 AM | |||
04-15-2021 10:31 AM | |||
03-06-2024 09:43 PM | |||
02-02-2024 02:09 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |