Better Income Statements with Calculation Groups? (PowerBI Tutorial)
Vložit
- čas přidán 1. 08. 2020
- 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.
Link to blog post: businessintelligist.com/2020/...
Was thinking this exact same method. Nice vid!!!
Appreciate it!!
Thank you! I knew that you have a guide on this!
Very Cool !!! Thank you for your creative and inspiring video!!!
You are welcome, glad you enjoyed it!
Just finished an income statement in PBI, including LY, YTD, Budget and started thinking should be a better way to do it. Glad I found your video. I also agree with the conclusion, PBI cannot replace Excel yet
yup and that's too bad...
I was able to do it without Calculation Groups and it looks perfectly well and can be exported to Excel. The income statement is collapsible using a Matrix in Power BI
I don't know of another way to format things on a fly as numbers, percent or currency. Curious to know how you got it to work without using Calculation Groups.
Hey, this is nice video! Thanks for sharing! I really love it!
Thank you too
Thanks. Tried the income statement. Appreciate if u can advise whether we can do some formatting using the conditional format such as adding color on certain rows?
Great video, thanks for taking the time!
Yep blank spaces are ignored so you need to use character map as you did for blank space...
A couple of questions, How can we do a blank line or apply text formatting to the calc item names like bolding text ?
I think the blank line is impossible, nor is it possibly to format individual lines on the table/matrix visual. Unfortunately, until we get a better visual, those things will be not possible
Cool stuff .. Was playing around with Calc groups last week . Very handy.. However it would have been nice if we can dynamically name the calculation items .. so that it can be iterated with slicers - which will have the visuals updated with the same term which is being selected .. Any thoughts around this ??
For sure, that would have been awesome! However, I don't think that's on the road map for calculation groups... I am hoping that now that this feature is available in the Desktop, we are going to see a lot more enhancements. Technically, it's been around for a year, but only now are we able to start to actually do something useful with it.
thanks for this wonderful content.
May I know how can you add py, yoy and yoy using this approach?
we would need to add a table that has a column for those scenarios, then add that to the columns in the matrix control and then change the calculation group logic for each line item to check what scenario we are in and return the corresponding measure... i will do a follow up video hopefully soon to explain how to do it. Kind of hard to explain in the comment.
@@KnowledgeBankPro First of all - thanks for the really helpful content. Instead of waiting for a follow up video, do you think you could provide the DAX (or general idea) for how to check "what scenario we are in"? Would we do that based on the Date dimmension in the current context or is there a smarter way? Any hints would be appreciated.
@@ragnareiriksson4769 in you table chart, the calculation items go into rows, then you create another table with a column that has different scenarios (This Year, Last Year, Budget, Forecast, % of LY, etc).. that data will go into the Column of that matrix. Now you can use selectedvalue(scenario[name]) in each calculation item to return the measure as This year, Budget, Forecast, % of LY, etc)... hope it makes sense...
@@KnowledgeBankPro Thanks again. I think I understand what you're saying, but not sure how all the scenarios can be showed at the same time - each in a seperate column? I suppose I could create as many matrix visuals as there are scenarios but that's just not very elegant. But maybe I'm beeing greedy here!
@@ragnareiriksson4769 i will try to do a follow later this week and explain how this works