Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 created measure which helps me to represent balance sheet data per periods:
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.
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:
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 )
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |