Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to generate few S-curves. The plan curves are looking good, only issue is it is not starting from zero.
but the real issue is the actual curve is going all the way to the right.
Is there any way to stop it in the last value of actual? And I need this for Date Hierarchy (meaning rolling up to Week - Month.
Any help is highly appreciated.
Best regards,
Sumit
Solved! Go to Solution.
@Anonymous change your cumulative measure like this
Cumulative measure =
<<current measure calculation>>
* DIVIDE ( [Weekly Measure], [Weekly Measure] )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous change your cumulative measure like this
Cumulative measure =
<<current measure calculation>>
* DIVIDE ( [Weekly Measure], [Weekly Measure] )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks for your help. It worked like magic in monthly, but the actual curve disappeared when drilled down to weekly.
Any idea, how to bring that curve back in weekly scale?
I could get it back. It was due to a different [Date] field from the calendar. You solved my problem.
Thanks a lot mate.
Best regards,
Sumit
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |