Power Platform Community Forum Thread Details

We use Papercut to email scheduled reports which i'm picking up with automate, the report i'm interested in is around Environmental Statistics.

Department	Trees Consumed	CO2 Produced	Equivalent Bulb Hours	Sheets	Total Printed Pages
[No department]	8.748% of a tree	9.3 kg	579.7 hours	729	801
xxxx	1.200% of a tree	1.3 kg	79.5 hours	100	155
xxxx	1.08 trees	113.8 kg	7,124.7 hours	8960	11760
xxxx	1.70 trees	179.5 kg	11,239.7 hours	14135	16059
xxxx	2.196% of a tree	2.3 kg	145.5 hours	183	261
xxxx	1.560% of a tree	1.7 kg	103.4 hours	130	139
xxxx	11.760% of a tree	12.4 kg	779.3 hours	980	1059
xxxx	6.38 trees	675.6 kg	42,298.1 hours	53194	67623
xxxx	4.38 trees	463.1 kg	28,995.8 hours	36465	46453
xxxx	2.34 trees	248.0 kg	15,524.8 hours	19524	22882

The first issue, is the bizarre usage of percentage and then decimal for trees and then its a pain because they use a comma in the larger numbers for bulb hours. Those are fine because i can exclude that data and calculate it myself with a new measure and the data from sheets column (in PBI).

I'm creating a new CSV table prior to saving it with the below columns. I can get the department column, Total printed Pages as using last() but i'm struggling with getting sheets. Is there a function to count back from last? If i use split and count the occurrence it throws it off as some data in bulb hours has commas and others do not. This throws the count out.