About The BIccountant

Hello and welcome to my blog! My name is Imke Feldmann and here I will share my ideas and concepts about utilizing Micrsoft’s cool new BI tools primarily in the Finance and Accounting area.

I’ve been working as a Finance Director, Head of Accounting and Controller for over 15 years. There I fell in love with Microsofts self service BI stack and decided to focus completely on bringing these tools to life. Now I’m providing BI training, consultancy services and developments mainly remote over the internet, living happily ever after…

Just send me an e-mail if you are interested in my training- or consultancy-services: info@thebiccountant.com

I engage in the PowerBI and Excel community and taking pride in having been awarded as a Microsoft Most Valuable Professional for my contributions in 2017.

Hoping that my blog will spread some of the fun I’m having with it and will help you improve your daily work.

Enjoy & stay queryious! 🙂

imke

 


Comments (14) Write a comment

  1. Hi Imke,

    Just to say thank you for the very nice blog you’ve created, I really like how devoid of noise and full of information it is!

    I also love how you’ve put links to the blogs of other experts in this area (Ken Puls, Marco Russo etc), I think it is very professional and stands for the community kind of thinking I find really useful on large scale.

    Thank you once agian.

    Vitali

    Reply

  2. Pingback: Computing the Longest Lived US President with Power Query | Math Encounters Blog

  3. Imke, your PL stuff is just amazing I’m Finance Director for a group of 9 motor dealerships.
    So you can imagine the complexity. New/Used vehicles; Cars/Vans, Vehicle Models, 9 sales types, multiple franchises, Sales, service, parts, bodyshop, rental, fuel sales etc etc.

    I started power bi in January this year and your inspiration on PL has encouraged me to develop what should become a working solution.

    I’m making big use of the matrix visual as you can imagine with expected columns showing MTD Act, bud and LY with variances, and same for YTD. I’m overcoming Microsoft’s shortfall in formatting by applying the line description as a value rather than a row header and all is working well.

    Questions:
    1. Is there a way of eliminating rows with zero/null values on all columns?
    2. Is there a way of applying the line description as a row header rather than a value and conditionally formatting it? Whilst single depts. work OK with line desc as a value, this doesn’t work
    when applying site colum headers because the line desc just repeats.

    Again just awesome, simple tips in a world that can get very techy. Thank you

    Pete

    Reply

    • Hi Pete,
      thanks for great feedback!

      Re 1: If my understanding is correct you’d have to create a text measure for your line description that returns BLANK() if the respective combination of your (number) measures return BLANK as well. So not a particularly dynamic solution unfortunately.
      Re 2: Unfortunately not. Pls make sure to vote up the ideas in the PBI forum for this: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in

      Reply

      • Hi Imke,
        Will try blank idea and await MS on other.

        I have another issue now. I am trying to bring the model back to Excel via Excel publisher for power bi. It is all connecting wonderfully and I can see the model. But when I place the measures for the P and L into the values section of the PT (ie your magic measure) no amounts appear in the pivot table??

        Any ideas??

        Pete

        Reply

        • Hi Pete,
          no idea really – please make sure to compare your model in detail to the sample xlsx-file you find in the blogpost.
          /Imke

          Reply

Leave a Reply

Die Datenschutzbestimmungen finden Sie hier: / Please find the privacy policy here: https://wp.me/P6lgsG-Rz