A short while ago I did a video about how hard it was (or almost impossible) to build a good Income Statement in Power BI. Now that the Calculation Groups are here, the question is whether we have a better option than what I had to do before with a smart calculation. If you are short on time, I will not make you suffer through the entire video, and just answer– yes, calculation groups are better than smart calcs. However, the real question is how much?
In the video, I walk through all the steps of necessary to create an income statement using calculation groups and compare and contrast that approach versus the steps that I took with my smart calculation before. I am also making the model available for you to download here.