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
Hello,
I'm looking for guidance. I need assistance in creating a dax formula that will distribute the values based on date range.
Example: 6/1/2020 thru 8/31/2020 Total value: 6000
Output:
Date Value
6/1/2020 2000
7/1/2020 2000
8/1/2020 2000
The calculation should be done based on monthly distribution.
Regards,
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!