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
Community 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.