Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have a report that brings together data from a table, and groups data per month by summing numbers. I need to calculate the average of the column totals (Fiscal Month), NOT the average of each column plotted for that data if that makes sense.
The standard AVERAGE just takes the average of each fiscal month, and plots that. I hope this makes sense. Any help greatly appreciated.
@MontyUK ,
Can you provide one example with the sample data what you have? or else check the below thread whether it is solving your requirement.
Thanks,
Arul