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! 🙂



Comments (22) 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.



  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.

    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



    • 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


      • 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??



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


  4. Hi Imke, didn’t you write a post about how to see dax-calculation while you write the code………..I can’t find it. Sorry, if my memory is wrong. And by the way……….love reading your stuff:-)


  5. Imke –

    When will you write a book? Your M knowledge and insight is unique – you toss off compact solutions in forums to complex problems with barely a pause. Your solutions to looking ahead and behind on rows, load factors for trucking, generating combinations and permutations, etc are miracles.
    Personally, I struggle to understand what you’ve done because your code is so compact… I’d love it if you explained step-by-step what seems so simple to you. So I eagerly await a book, or at least taking your posts and giving us a detailed explanation.


  6. Dear Imke, just wanted to say thank you for all you are doing for the PowerBI and Power Query community. You are a true North Star for any issue encountered 🙂


  7. Pingback: How to Effectively Manage Your Budget When Starting a Business -

  8. Pingback: Power Query infer data types with Table.Profile | Patrick O'Beirne @ sysmod

Leave a Reply

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