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.
I have a file containing the monthly planned values (PV) for each project & expense. This file can contain updates to these existing projections. So any given Month/Project/Expense (Key) can have orginal, monthly, and most recent updates.
This column works to always provide the original values:
Hi @steph_io
It seems you may try to use ALLSELECTED Function. Below is the post for your reference. If it is not your case, please share the simplified data sample and expected output so that we could help further on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
https://community.powerbi.com/t5/Desktop/Cumulative-with-a-slicer/td-p/469928
How to Get Your Question Answered Quickly
Regards,
Cherie
The issue with All Selected is that it will only show amounts that have a updated value. I need to accumlate the amounts upto and including that quarter. Some periods have no udpates but the accumulated total still applies.
I have budget data per month spanning 2017 - 2024, but so far I only have 5 updates (2017-09, 2018-01, 2018-04, 2018-07, 2018-10). These updates can be to some past and/or future months. When there is an update, I need to use that value within the updated range.
So again it's not as of 'today's cumulative latest value. I need to plot it as it's been updated.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
80 | |
61 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
104 | |
78 | |
71 |