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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello,
for example: If I slice the target from any month between Jan-21 to Mar-21 it should display the same target for Jan, Feb, Mar. And For Apr-21 to Sep-21, it should display the same target for Apr, May, Jun and so on.
Here is the Dataset.
Thanks in Advance !!
@Tejaswini_Dahat , refer if this blog of mine can help
How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
Or the attached file after the signature of similar topic
Hello @amitchandak,
Thank you for the help. Actually, I don't want to divide the target for the months. Target should be the same for individual months and for all the months from start month to end month.
Just like: from Jan-21 to mar-21 the target is 1000000, so it should be the same for each individual months for Jan target should be 1000000, for Feb 1000000 and for Mar 1000000 and for Jan-21 to Mar-21 also 1000000.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
14 | |
12 | |
10 | |
9 |