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.
Hi there,
I have a table with ProcessDate, Branch Name, and Balance by Branch. And i am looking to get the average of the balance by branch by process date range. Can you please tell me how to do it?
The process date is a range slicer.
Thank you
Glen
Solved! Go to Solution.
Hi @gco ,
Drop the The Branch Name on Columns and see measure below for value.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Average Balance = CALCULATE(AVERAGE(Branch[Balance]),ALLSELECTED(Branch[Date]))
Proud to be a Super User!
Hi @gco ,
Drop the The Branch Name on Columns and see measure below for value.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Average Balance = CALCULATE(AVERAGE(Branch[Balance]),ALLSELECTED(Branch[Date]))
Proud to be a Super User!
You rock!!! This is exactly what i was looking for. Millions of thank you for you!!!
Glen
Anytime!
Proud to be a Super User!
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.