Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
My name is Morgan Klaif and I work at the Summit Area YMCA. Our old Manager of Digital Marketing introduced us to Power BI. With him now gone, I have taken responsibility of the software, so I am still relatively newer to using it.
One of the reports I have recently created is a Monthly FTE report which shows childcare information. I am trying to figure out how to go about created two extra columns that would show a running total and an average of that running total.
Here are the details:
Since there is a slicer, I am not sure how to go about adding in a calculation that would show the running total for that program and the average of that total for that program, up to and including the selected month of the slicer.
Here's an example of what I'm talking about:
In the below table, you can see the actual FTE for BH Before Care is 37.8. Having "11" selected on our Month slicer, this is data from the Months folder and taken from the November spreadsheet.
I need to figure out how to add two columns next to "Actual FTE".
I tried searching the forum before I posted this, but all the examples were based on date values. This report doesn't use dates, rather than all text/decimals/currency, with the Month selection being text for the month names for the data spreadsheets and whole number for the month numbers.
Any help to get those two columns would be a tremendous help.
Solved! Go to Solution.
You may view the code generated by Quick measure Running total and Rolling average and try using ALL instead of ALLSELECTED.
You may view the code generated by Quick measure Running total and Rolling average and try using ALL instead of ALLSELECTED.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |