Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a requirement where in I need to display total revenue as on the selected date and them show it for indiuidual months in the selected intervals, I have tried creating an YTD measure but it doesn't meet my requirement,
I am attaching the screen clip for the reference.
As it can be seen in the slicer the selected dates are 06-01-2019 to 30-11-2019, so my requirement is at the starting of the date(i.e) 06-01-2019 i want to see total revenue of previous time and then it should be individual revenue for each months.
I am struggling to figure out a way to resolve this, I would be thankful if i can get any help.
Solved! Go to Solution.
@Anonymous try this measure , for this kind of calculations it is suggested to have calendar table in your model.
Running Total =
CALCULATE (
SUM ( 'Table1'[Revenue (Base)] ),
FILTER ( ALLSELECTED ( Table1 ), Table1[Effective Start Date] <= MAX ( Table1[Effective Start Date]) )
)
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 try this for running total
Running Total =
CALCULATE (
SUM ( Table[Amount] ),
FILTER ( ALLSELECTED ( Calendar ), Calendar[Date] <= MAX ( Calendar[Date] ) )
)
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 @parry2k
I have got the running totals, but still i can't figure it out how to display the total revenue since strating of time at the selected start date, running total is giving me the total of staring month and then it move forward adding up revenues for each month.
Thanks.
@Anonymous the measure should start from the first date selected in the slicer? Is that not working? If not can you share pbix file with sample data?
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.
@parry2k Here is the link to the sample .pbix file, Please do let me know if this can be achieved.
https://drive.google.com/open?id=1WYht_KjAsy1s9OJOpEn6djXrhNdL4r3l
Thanks
@Anonymous try this measure , for this kind of calculations it is suggested to have calendar table in your model.
Running Total =
CALCULATE (
SUM ( 'Table1'[Revenue (Base)] ),
FILTER ( ALLSELECTED ( Table1 ), Table1[Effective Start Date] <= MAX ( Table1[Effective Start Date]) )
)
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |