Any alternative for if-else-if statement apart from custom column which can prevent data refresh

[blokesh23]

We have loaded huge volume of data(> 1M) from database into PowerBI through ODBC connection.

Need to create a custom column based on if-else-if statement with several and conditions . I have used Custom column option but once I apply changes , the report is again hitting DB for loading data which is taking lot of time.

Is there any other alternative where we can prevent report refreshing data from database.

Thanks !

[amitchandak · Accepted solution]

@blokesh23 , In power query it will. In DAX you can use Switch, bit costly but will work with loaded data

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

[blokesh23]

Thanks worked as expected

[v-jayw-msft · Accepted solution]

Hi @blokesh23 ,

You could try unchecking the Enable load option before creating custom column and enable it after the columns being created.

Best Regards,

Jay

[amitchandak · Accepted solution]

@blokesh23 , In power query it will. In DAX you can use Switch, bit costly but will work with loaded data

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56