Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
25 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
25 | |
12 | |
11 | |
10 | |
6 |