Forum Discussion

Charli's avatar
Charli
Frequent Visitor
2 years ago

Income statement variation column

Hello all,   After building my income statement, I am trying to introduce some variation column. For example I want to show the variation between last year actuals and this year in value (N - N-1)...
Need Help
Charli's avatar
Charli
Frequent Visitor
2 years ago

Hello audreygerred and thank you for your help!

Unfortunatelly, I don't have the possibility to install Tabular Editor on my PC (restriction imposed by the company) ... Would you know any other way to proceed please ? 

Thank you

audreygerred's avatar
audreygerred
Super User
2 years ago

You can do calculation groups directly in Power BI desktop as well (as long as you have the October 2023 version). You just need to go into your preview features and turn it on. 

  • Charli's avatar
    Charli
    Frequent Visitor
    2 years ago

    I don't know if the calculation group is the sollution, I tried to input the YTD measure but it doesn't really work. And it's not really what I am looking for as I already have all the period and year I need, I just want to calculate some simple variances between two collumns (in value and %) and on multiple values (revenue, external cost of revenue etc.).
    If it is through the group calculation, do you have any formula for that please? Or maybe there is another solution?

    Thank you again