Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hey,
I have :
Calendar table (with year, month, quarter etc.) (calendar_v) and Contracts table which is filtered by Calendar_v (date filters -> start_date). My Contract table have monthly amount which should be calculated to a Total between start_date and end_date (but still should be filtered by calendar).
So let's say for contractor issue id 362030 , I have monthly amount of 1000 , start_date is 01.01.2023 and end_date is 31.01.2024.
So total value of contract will be 12 000 (as it's full 12 months), but if I filter with calendar to 2023 it should only show the part for 2023 which is 11 months * 1000 = 11 000.
I would also be able to put this on time series and split it into Year-Month from the calendar.
Is there a way to create a DAX formula without any additional helping tables? (which would kind of calculate an extra table with every month between start date and end_date and create). I want to simplify my model as possible.
Here is sample data:
https://drive.google.com/drive/folders/1rSqX30l9CmzlYCLKA5lyvRRTJNzZHatt?usp=share_link
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 13 | |
| 10 |