Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |