How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle?
Check how Calculation Groups can help you to achieve the (im)possible! — Dear reader, before you proceed, keep in mind that the following example was a real-life use case! Of course, numbers and metrics in this article were adjusted not to discard the real client’s data, but the structure and overall idea is 100% identical as it was in reality!