Forum Discussion

Tatmel's avatar
Tatmel
Frequent Visitor
6 years ago

Balance sheet total. How to improve performance. Current measure works very slow

Hello, I need some help with following issue. I have GL entry table with GL No, Amount, Posting Date and Index.   I also have calendar table where I have unique dates. Based on two tables I creat...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Tatmel ,

 

You could use VAR to define your filter at first.

And you could check if your Power BI is 64-bit version.

Make sure that no other software that consumes too much memory runs at the same time while running Power BI.

 

Tatmel's avatar
Tatmel
Frequent Visitor
6 years ago

Hi v-eachen-msft ,

 

I have 64bit version of PBI installed on my PC.

Can you please show how new measure will look like by using VAR?

Current measure looks like this:

Balance = calculate(sum(QGLEntry[Amount]);DATESBETWEEN('calendar'[Calendar Days];DATE(1950;01;01);ENDOFMONTH('calendar'[Calendar Days])))
Thank you in advance!
  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Tatmel ,

     

    You could refer to the following measure.

    Balance =
VAR a =
    SUM ( QGLEntry[Amount] )
VAR b =
    DATESBETWEEN (
        'calendar'[Calendar Days];
        DATE ( 1950; 01; 01 );
        ENDOFMONTH ( 'calendar'[Calendar Days] )
    )
RETURN
    CALCULATE ( a; b )

     

    • Tatmel's avatar
      Tatmel
      Frequent Visitor
      6 years ago

      Hi v-eachen-msft ,

       

      I've tested your measure and noticed that it gave different result compare with initial measure I've used in my calculations.

      When I added to my pbix I got negative balance for fixed assets which couldnt be possible.