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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I need help in below calculation:
I have around 500 vendor invoices with different amounts, and with different time frames. I should calculate somehow the amount falls from the total invoiced amount into for example quarter 1 in 2020 (01/01/2020 - 31/03/2020). Thanks for any help! Time Intelligence Date Question Date Comparisons
| Vendor | Allocation USD | Start Date | End Date | Quarter 1 2020 |
| XXXXX | 500 | 1/9/2019 | 30/09/2020 |
Hi @EszterLauter , can you please explain your question a bit further, as to what exactly are you trying to calculate. We might be able to assist
@EszterLauter , Not very clear, see on of the two can help
Or the file
https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0
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 |
|---|---|
| 93 | |
| 81 | |
| 73 | |
| 46 | |
| 35 |