Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.