Forum Discussion
Solved
SP Lists Monthly Total
Using SP Online Lists I have a simple purchase list that details purchases by date, e.g.; +----------+-------------+-------+
| date | description | price |
+----------+-------------+-----...
jonboylib whilst I agree with Bharath Arja about Power BI, it comes with issues around distributing reports because all users need a Power BI Pro licence to view a report.
But a simple solution and keepng it all in SharePoint is to have a calculated column for the Month, in my example the formula is =TEXT([Insurance Expiry Date],"MMM YYYY").
Then create a new view of the list and group by that month column and set the total to sum the amount column. It will always update as new items are added to the list.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Calculated columns may not be relevant for what you are looking to accomplish.
Are you licensed to use PowerBI? Did you check the out of the box visualization of your List that is available in Power BI. Go to your list -> In top ribbon select Integrate drop down -> PowerBI -> Visualize the list.
Keeping data in your list and creating totals or reports in PowerBI works out better in most of the scenarios.
Are you licensed to use PowerBI? Did you check the out of the box visualization of your List that is available in Power BI. Go to your list -> In top ribbon select Integrate drop down -> PowerBI -> Visualize the list.
Keeping data in your list and creating totals or reports in PowerBI works out better in most of the scenarios.