Forum Discussion
Average Calculation in Table Visual
Hi tanmaym93 ，
Thank you for your detailed description, I now have a general understanding of the construction of your table, can you please tell me more about the specific calculations you are currently trying to complete?For example, what data do you want to use to get a result?
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Selina - Great! So now, in terms of what data I would like to use - I am using the HC_New & Exit_New fields to calculate my results.....
My table visualization looks like this and I am looking to add 2 more columns to this table - Cumulative Avg Headcount (as per my initial post) & YTD%:
YTD% will be Cumulative Exit/Cumulative Average Headcount.
I am not sure, but does this help?
Thanks & Best Regards
Tanmay Mukherjee
Hi tanmaym93 ,
Sorry for the late reply, thank you for your very clear description this time ~ it made me understand what you want to achieve.🤗
Did you get your problem solved?
I wonder if it would be convenient for you to give me a sample data or preferably a PBIX file (without private information), so that it would be easier for me to do the calculation for you.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Selina - Apologies for the delay, I am unable to attach any file as I et an error that the file extension is not supported (slsx or pbix).. However, I can share a snippet, woud that help?
Thanks & Best Regards
Tanmay Mukherjee