Forum Discussion
luxpbi
Helper V
Helper VPower BI Desktop Extremely Slow
Hi, The fact is that I have a not very big pbix. It's 32MB size. I've create a calculated column, a little bit complex, but it works. The problem is that since then the pbix is extremely slow, for...
Kumail
Impactful Individual
Impactful IndividualTestDays =
VAR CurrentProduct = 'Table1'[Product]
VAR CurrentState = 'Table1'[Status]
VAR CurrentDate = 'Table1'[Date]
VAR CurrentNMov = 'Table1'[Index]
VAR CurrentCodTaller = 'Table1'[Type]
VAR NextStateDate =
CALCULATE (
MIN ( 'Table1'[Date] ),
KEEPFILTERS ( 'Table1'[Status] <> 8
|| 'Table1'[Status] <> 9 ),
FILTER (
'Table1',
'Table1'[Product] = CurrentProduct
&& 'Table1'[Date] >= CurrentDate
&& 'Table1'[Index] > CurrentNMov
&& ( 'Table1'[Type] = BLANK () || 'Table1'[Type] <> CurrentCodTaller || 'Table1'[Type] = CurrentCodTaller )
)
)
VAR LastMov =
CALCULATE (
MIN ( 'Table1'[Date] ),
FILTER (
'Table1',
'Table1'[Product] = CurrentProduct
&& 'Table1'[Date] >= CurrentDate
&& 'Table1'[Index] > CurrentNMov
)
)
RETURN
IF (
ISBLANK ( LastMov ),
( TODAY () - CurrentDate )
+ 1,
( NextStateDate - CurrentDate )
+ 1
)Even in measure, its working perfectly fine; as fast as any other feature in power bi
luxpbiHelper V
Helper VWorks fast because of the size of the dataset. When you have 2 million rows is veeeery slow..
Do you think is there a way to optimize it?
- Kumail
Not sure. Actually I was extremely busy on something therefore, couldn't reply you yesterday.
I have used python for my clients for processing large dataset and created a csv or excel file for visualization (If you are not querying data directly from CRM). That generally works well for me.